select *
from ORN_CAST_OBCE orn_cast_obce
left outer join ORN_OBEC orn_obec on orn_obec.kod = orn_cast_obce.obec