Distinct rows

From: Chris Jordan <mail_at_mailer.com>
Date: Fri, 22 Oct 1999 10:28:41 -0400
Message-ID: <9k_P3.4693$Qo3.96613_at_wbnws01.ne.mediaone.net>

[Quoted] [Quoted] Hi I have a query (select vendorid, product, description from vendors where [Quoted] [Quoted] vendorid < 100) that is returning duplicate information, ie.

[Quoted]     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, [Quoted] i.e in the above, only vendorids 1 & 2 are [Quoted] displayed for a total of two records(1,switches,RKS) and (2,UPS,New).

Thanks,
Chris Received on Fri Oct 22 1999 - 16:28:41 CEST