Thanks Larry. I used a little different technique but your use of subquery in the WHERE clause seems most appropriate for this.
>
>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
It's "my" world. You're just living in it.