Hi there!
I'm new to SQL and I can't figure out a query which would give me the result
I need. What I want to do is this:
I have table that stores names of players and number of the game they play
(one player can play more games concurrently). Other users can join the
game. For given user I want to display the games which he can join. The only
condition is that the user can't join any game which he already plays.
If I have this
+-----+---------+
| gid | user |
+-----+---------+
| 1 | jack |
| 1 | john |
| 1 | peter |
| 1 | richard |
| 2 | john |
| 2 | richard |
| 3 | peter |
| 4 | jack |
| 4 | peter |
| 5 | peter |
| 5 | john |
+-----+---------+
then for jack I want numbers 2, 3, 5 but not 4; for peter it should be 2 and
no other.
I'll appreciate your advice!
zbynek
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php