select * from OOB_ORDERS oob_orders left outer join OOB_CUSTOMER oob_customer on oob_customer.idpk = oob_orders.idpk_customer