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]
