select * from D4_LP_RADEK d4_lp_radek left outer join D4_LP_LEKAR d4_lp_lekar on d4_lp_lekar.idpk = d4_lp_radek.idpk_lekar