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 duplicates should be returned. In this example, 12 and 15 will be returned, but 10 won't. I can think of a few awkward ways to do it, but am looking for a simple one. I'm not that familiar with MySQL.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- RE: Select IDs that only have 1 entry Todd Ashworth
- RE: Select IDs that only have 1 entry Burns, John D