SELECT A.FMTITEMNO AS partn, A.DESC AS descr, CAST (B.RECENTCOST AS decimal(10, 2)) AS buyp, CAST (A.OPTAMT AS decimal(10, 2)) AS sellp 
FROM mwp.icitem A, mwp.iciloc B 
WHERE A.itemno = B.itemno