[thelist] duplicates

Ken Schaefer Ken at adOpenStatic.com
Tue Apr 12 09:28:28 CDT 2005


SELECT DISTINCT

may help. But you really need to provide some sample data, and sample output
for us to be able to provide a definitive answer.

Cheers
Ken

--
www.adOpenStatic.com/cs/blogs/ken/ 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of Dan McCullough
: Subject: [thelist] duplicates
: 
: 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