select *
from OOB_DISTRICT oob_district
left outer join OOB_WAREHOUSE oob_warehouse on oob_warehouse.idpk = oob_district.idpk_warehouse