Distinct rows
From: Chris Jordan <mail_at_mailer.com>
Date: 1999/10/22
Message-ID: <9k_P3.4693$Qo3.96613_at_wbnws01.ne.mediaone.net>#1/1
Date: 1999/10/22
Message-ID: <9k_P3.4693$Qo3.96613_at_wbnws01.ne.mediaone.net>#1/1
Hi I have a query (select vendorid, product, description from vendors where
vendorid < 100) that is returning duplicate information, ie.
What query can I use that displays only one instance of a specifc vendor,
VENDORID PRODUCT DESCRIPTION
1 Switches RKS
1 Switches DDK
2 UPS New
Thanks,
Chris
Received on Fri Oct 22 1999 - 00:00:00 CEST