Dear Barbara,

sCode = Supplier's product code
sDetail = supplier's product description
pCost = Product's Cost
pDiscount = Product's discounted price
sID = supplier's ID
oMID = our Product code

I would like to select from the purchasing history to form a list of product code available with the same product and same supplier, i.e.

SELECT DISTINCT sCode,sDetail,sID,oMID FROM stockPurchase WHERE sID= ?lsID AND oMID = ?loMID ORDER BY sCODE

However, it is more informative if I can add pCost & pDiscount for reference...

SELECT DISTINCT sCode,sDetail,pCost,pDiscount,sID,oMID FROM stockPurchase WHERE sID= ?lsID AND oMID = ?loMID ORDER BY sCODE

However, in that, even there is price difference, there will be additional record for that... so I don't want it...