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
It's "my" world. You're just living in it.