Select IDs that only have 1 entry

I have a table a bit like this: id whatever1 whatever2 -- 10 - blah1 - blah2 12 - abc1 - abc2 10 - xyz1 - xyz2 15 - pdq1 - pdq2 I'm trying to come up with a query that will only pull the rows that have 1 entry and 1 entry only. None of the ones that have

RE: Select IDs that only have 1 entry

: Select IDs that only have 1 entry I have a table a bit like this: id whatever1 whatever2 -- 10 - blah1 - blah2 12 - abc1 - abc2 10 - xyz1 - xyz2 15 - pdq1 - pdq2 I'm trying to come up with a query that will only pull the rows that have 1 entry and 1 entry only

Re: Select IDs that only have 1 entry

, 2004 4:16 PM Subject: RE: Select IDs that only have 1 entry I have thought about the same thing.I've also wondered about a NOT DISTINCT command to find records that do have duplicates.Anyone with any bright ideas? John [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe