I have a database field that sorts out duplicate entries that exist in the same field, with this:
SELECT *, a.ID from Products as a, Products as b where a.ProdDesc = b.ProdDesc and a.ID != b.ID AND a.ID > b.ID ORDER BY a.ID
How would I be able to change it, so that it will group the two that are match together. Like, say ID 254 matches the product of 300, and 360 matches 109, I want it grouped as :
254
300,
360
109
etc. Any ideas?
