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