select *
from OOB_CUSTOMER oob_customer
left outer join OOB_DISTRICT oob_district on oob_district.idpk = oob_customer.idpk_district