select * from D1REG d1reg left outer join O0CISELNIK o0ciselnik on o0ciselnik.idpk = d1reg.idpk_job_druh