[thelist] duplicates

Jay Blanchard jay.blanchard at niicommunications.com
Tue Apr 12 09:33:51 CDT 2005


[snip]
Is there away in a query to add to the select statement that if there
is more then one record of the same id not to pull it.

That might be a bit confusing, but basically I have a summary table of
categories and products, and a single product can go into multiple
categories.  So I am pulling certain certain information from the
summary table and certain information from the product table.  So I
will get get 2-3 rows that are the same id.
[/snip]

GROUP BY id


More information about the thelist mailing list