[thelist] duplicates

Joshua Olson joshua at waetech.com
Tue Apr 12 09:31:50 CDT 2005


> -----Original Message-----
> From: Dan McCullough
> Sent: Tuesday, April 12, 2005 10:11 AM
> 
> 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.

This is by and large the same SQL question asked yesterday about grouping.
Check there for some pointers.

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168 




More information about the thelist mailing list