select * from OOB_STOCK oob_stock left outer join OOB_WAREHOUSE oob_warehouse on oob_warehouse.idpk = oob_stock.idpk_warehouse