I have the following table - --------------- + RESULTS + --------------- pk | user | round 1 | 8 | 1 2 | 8 | 2 3 | 8 | 3 4 | 5 | 1 5 | 5 | 2 6 | 5 | 1 7 | 2 | 3 How can I go about selecting all the user id's but only where that user has round 1,2 and 3. This means from the above example I would only have user - 8 returned. I'm using MySQL. Many thanks in advance.
Forum Rules
Bookmarks