select vdr.vendorID from Vendor vdr where vdr.state in 
   (select vdr1.state from vendor vdr1 group by state having count(state)>1)

>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