Hello, I have problem with this syntax:
SELECT game_id FROM game WHERE game_id NOT IN (SELECT game_id FROM player WHERE user_id!=$id_user) I need select games where user is not connected. I have two tables game(game_id, ....) and player(player_id, game_id, user_id, ...). In table player are many players in one game. ____________________________________________________________ http://www.bezpecnyinternet.cz http://ad.seznam.cz/clickthru?spotId=80833 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
