I can't seem to figure out how to gather the found set I need...???

[angelleye]

I have a table called Auctions that has both an ItemNumber and a ScanID in it. ScanID's are unique to ItemNumber's, so if I have 10 auction records with the ScanID 12345 they should all have the same ItemNumber.

Somehow I've gotten lots of auction records that are getting incorrect ScanID's. I need to figure out how, but right now I simply need a way to find all of the problem records.

I can put a ! in the ScanID in Auctions to get a found set of records with duplicate ScanID's, however, I don't know what to do from there in order to filter so that I only see records with duplicate ScanID's but different ItemNumber's.

Any information would be greatly appreciated. Thanks!