title: Querying multiple nested objects on multiple paths
body: <p>Is it possible to <a href="https://www.elastic.co/guide/en/elasticsearch/guide/current/nested-query.html#nested-query" rel="noreferrer">query</a> multiple nested objects <strong>on different paths</strong> in Elasticsearch? I can query one nested object on one path but I can't find the correct syntax to query two objects on different paths. </p>
  
  <p>I need to query with the logic like the following:</p>
  
  <pre><code>{'query': {
     'bool': {
         'must': [
             'nested': {
                 'path': 'Diagnosis',
                 'query': {
                     'bool': {
                         'must': [{'match_phrase': {'Diagnosis.Diagnosis': {'query': "epidemia"}}}]
                     }  
                 }
             },
             'nested': {
                 'path': 'Demographic',
                 'query': {
                     'bool': {
                         'must': [{'match_phrase': {'Demographic.Gender': {'query': "female"}}}]
                     }  
                 }
             }
         ]
     }
  }}
  </code></pre>
  
  <p>The ultimate goal is to denormalize my PostgreSQL DB data (72 tables, over 1600 columns in total) and be able to use boolean queries over it.</p>