SQL question / advice

[eluser]drewbee[/eluser]
Perhaps if you post the table structure, we can help you out further.

I can't remember specificially for mysql's DISTINCT behavior, but I believe for a row to be identified as a duplicate, every column must match another column.


Anyways, the query I gave you above could actually be used as a nice starter as part of a subquery, then join all resulting rows based on that. Their are all kinds of things you can do actually.