select *
from ORN_KATASTRALNI_UZEMI orn_katastralni_uzemi
left outer join ORN_OBEC orn_obec on orn_obec.kod = orn_katastralni_uzemi.obec