title: Invalid Identifier on Sql left join oracle
body: <p>Hi I got some problems with the following Query </p>
  
  <pre><code>SELECT *
  FROM PARTNER P
       , ADDRESS A
       ,DOSSIERPARTNERRELATIONSHIP DPR
     LEFT JOIN PARTNERHIST PH ON P.ID=PH.PARTNER_ID
  WHERE (P.NAME ='Burger' OR PH.NAME='Burger')
   AND P.ID = DPR.PARTNER_ID
   AND A.PARTNER_ID = P.ID
   ;
  </code></pre>
  
  <p>when I'm trying to execute it I got the following error:</p>
  
  <blockquote>
    <p>ORA-00904: "P"."ID": invalid identifier</p>
  </blockquote>
  
  <p>Also when I'm trying the following I got the same error</p>
  
  <pre><code>SELECT *
  FROM PARTNER P
       , ADDRESS A
       ,DOSSIERPARTNERRELATIONSHIP DPR
     LEFT JOIN PARTNERHIST PH ON PARTNER.ID= PH.PARTNER_ID
  WHERE (P.NAME ='Burger' OR PH.NAME='Burger')
   AND P.ID = DPR.PARTNER_ID
   AND A.PARTNER_ID = P.ID
   ;
  </code></pre>