Invalid identifier on the left side of the Sql window

Question

Hi, I am having problems with the following query

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 ; 

when I try to execute it, I got the following error:

ORA-00904: "P". "ID": invalid identifier

Also, when I try to do the following, I got the same error

 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 ; 

Answer 1

Try the following:

 SELECT * FROM PARTNER P INNER JOIN ADDRESS A ON A.PARTNER_ID = P.ID INNER JOIN DOSSIERPARTNERRELATIONSHIP DPR ON P.ID = DPR.PARTNER_ID LEFT JOIN PARTNERHIST PH ON P.ID= PH.PARTNER_ID WHERE (P.NAME ='Burger' OR PH.NAME='Burger')