select * from C1ZAHR3 c1zahr3 left outer join O0CISELNIK o0ciselnik on o0ciselnik.idpk = c1zahr3.idpk_typ_zadani