select * from ZODECTY zodecty left outer join ZODECTY0 zodecty0 on zodecty0.idpk = zodecty.cis_zodecty0