select * from D4_LP_PECE d4_lp_pece left outer join D4_LP_LEKAR d4_lp_lekar on d4_lp_lekar.idpk = d4_lp_pece.idpk_lekar