Try this:
SELECT *FROM PARTNER PINNER JOIN ADDRESS A ON A.PARTNER_ID = P.IDINNER JOIN DOSSIERPARTNERRELATIONSHIP DPR ON P.ID = DPR.PARTNER_IDLEFT JOIN PARTNERHIST PH ON P.ID= PH.PARTNER_IDWHERE (P.NAME ='Burger' OR PH.NAME='Burger')