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