select * from C1ZALOHY c1zalohy left outer join O0CISELNIK o0ciselnik on o0ciselnik.idpk = c1zalohy.idpk_typ_platby