select * from ZOM_FA_SPOTREBA zom_fa_spotreba left outer join ZOM zom on zom.idpk = zom_fa_spotreba.idpk_zom