select * from ORN_STAVEBNI_OBJEKT orn_stavebni_objekt left outer join ORN_CAST_OBCE orn_cast_obce on orn_cast_obce.kod = orn_stavebni_objekt.cast_obce