select * from C0DIETY c0diety left outer join C0CESTY2 c0cesty2 on c0cesty2.idpk = c0diety.idpk_cesty2