It should be simple but for some reason I can't get it to work right.
I need to query a table and return the primary key if there are more than one record with the same value in another column. For example, I want the primary key of all Vendor records in which we have more than one in vendor in each state.
It's "my" world. You're just living in it.