select * from OOB_ORDER_LINE oob_order_line left outer join OOB_ORDERS oob_orders on oob_orders.idpk = oob_order_line.idpk_order