Actually, single table with:

TABLE: VENDOR
-------------
VendorID
Vendorname
Address
City
State
Zip
etc...

I want to retrieve all VendorID primary key where there are more than one vendor in any state.


>You want the ID of all vendors who service multiple states?
>
>Assuming two tables: vendors and VendorsInStates
>
>SELECT VendorID
>FROM VendorInStates
>GROUP BY VendorID
>HAVING COUNT(*) > 1
>
>If this isn't close, post the DDL.
>
>-Mike