Re: Question - SubQuery syntax

2004-12-21 Thread Jigal van Hemert
> 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 p

Question - SubQuery syntax

2004-12-21 Thread Jan Pešta
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 m