select * from OHOE_ZAK ohoe_zak left outer join OHOE_HL ohoe_hl on ohoe_hl.idpk = ohoe_zak.idpk_ohoe_hl