select * from OOB_STOCK oob_stock left outer join OOB_ITEM oob_item on oob_item.idpk = oob_stock.idpk_item