select * from ZODECTY zodecty left outer join O0CISELNIK o0ciselnik on o0ciselnik.idpk = zodecty.cis_z0tecprop