mysql duplicate sorting issue

[viveleroi0]

I have a mysql db, and a php program that uses the following query to find all duplicate listings...

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.ProdDesc, b.ProdDesc

But, does anyone how, with that query or otherwise, I can sort the results like so: product, matches other product. Basically, display what results matches what other result?

Right now, it just displays all matches randomly down the page.

[Sxooter]

select distinct * from table1 t1 join table2 t2 on (t1.key=t2.key) order by t1.productname,t2.productinfo

kinda thing