[thelist] duplicates

Dan McCullough dan.mccullough at gmail.com
Tue Apr 12 09:10:54 CDT 2005


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.


More information about the thelist mailing list