select * from ORN_STAVEBNI_OBJEKT orn_stavebni_objekt left outer join ORN_MOMC orn_momc on orn_momc.kod = orn_stavebni_objekt.momc