well, this doesn't work either. Because 'distinct' refers to entire record.
I want distict vendors. So from the example
below, only two records get returned instead of three as there are only 2
distinct VENDORS even though there are
3 distinct RECORDS.
Peter Okhiria <peter.okhiria_at_mci.com> wrote in message
news:38103931.A35CDAE2_at_mci.com...
> use
> select distinct vendorid, product, description from vendors where
> vendorid < 100
>
> Chris Jordan wrote:
>
> > Hi I have a query (select vendorid, product, description from vendors
where
> > vendorid < 100) that is returning duplicate information, ie.
> > VENDORID PRODUCT DESCRIPTION
> > 1 Switches RKS
> > 1 Switches DDK
> > 2 UPS New
> >
> > What query can I use that displays only one instance of a specifc
vendor,
> > i.e in the above, only vendorids 1 & 2 are
> > displayed for a total of two records(1,switches,RKS) and (2,UPS,New).
> >
> > Thanks,
> > Chris
>
>
>
Received on Fri Oct 22 1999 - 11:52:02 CDT
