[thelist] duplicates

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

> -----Original Message-----
> From: Dan McCullough
> Sent: Tuesday, April 12, 2005 10:11 AM

> 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.

Are the rows EXACT duplicates across all returned fields?  If so, then Ken's
suggestion to use the DISTINCT keyword will work.  If not, then you will
need to put in place logic to determine which of the rows of the same ID to
return.  Then, reference yesterday's thread, as suggested a few moments ago.

Joshua Olson
Web Application Engineer
WAE Tech Inc.

More information about the thelist mailing list