title: Inner Join operations between two Elastic Types inside a single Index
body: <p>I have two Types such as Employees and Cities inside an Elastic Index,</p>
  
  <p>The Type Employees  have document structure is like </p>
  
  <pre><code>[{
      "_index": "zase",
      "_type": "Employees",
      "_id": "100",
      "_score": 1,
      "_source": {
          "sid": 100,
          "name": "San Andreas",
          "stageid": 0
      }
  },
  {
      "_index": "zase",
      "_type": "Employees",
      "_id": "101",
      "_score": 1,
      "_source": {
          "sid": 101,
          "name": "Zack",
          "stageid": 0
      }
  }]
  </code></pre>
  
  <p>The  Type Cities have  document  structure like as Follows,</p>
  
  <pre><code>[{
      "_index": "zase",
      "_type": "Cities",
      "_id": "1",
      "_score": 1,
      "_source": {
          "sid": 1,
          "name": "Virginia",
          "EmployeesID": [
              0:100,
              1:125,
              2:143
          ]
      }
  },
  {
      "_index": "zase",
      "_type": "Cities",
      "_id": "2",
      "_score": 1,
      "_source": {
          "sid": 2,
          "name": "New Field",
          "EmployeesID": [
              0: 110
          ]
      }
  }]  
  </code></pre>
  
  <p>When Querying elastic search with  Cities name  'Virginia', I need to get the Employees information where  Cities.EmployeesID == Employees.sid,</p>
  
  <p>Is this RDBMS Join operation across different Types possible in   Elastic Search?
  Any help would be appreciated.</p>