select * from D1_OZ_PRUKAZ d1_oz_prukaz left outer join DAZAR dazar on dazar.idpk = d1_oz_prukaz.idpk_zamestnanec