select * from OOB_ORDER_LINE oob_order_line left outer join OOB_ITEM oob_item on oob_item.idpk = oob_order_line.idpk_item