mysql - 想要编写基于未出现在另一个表中的表中选择的查询

Question

我有三个表:player(playerId, Name) , game(gameId, gameName) ，和gameResults(gameId, playerId, results) 。

我想检索 gameResults 中的行哪里gameId表 game 中不存在.

我的查询是:

SELECT DISTINCT 
     gameresults.playerId, 
     gameresults.results    
FROM 
     game, 
     gameresults, 
     player
WHERE
     gameresults.playerId = player.playerId
     AND gameresults.gameId NOT IN (
       SELECT game.gameId; FROM game
     )

我也尝试过:

SELECT DISTINCT 
     gameresults.playerId,
     gameresults.results    
FROM 
     game, 
     gameresults, 
     player
WHERE 
     gameresults.playerId = player.playerId
     AND gameresults.gameId NOT EXISTS(
          SELECT race.raceId, FROM race
     )

Answer 1

SELECT DISTINCT gameresults.playerId, gameresults.results, game.gameName
FROM gameresults
  LEFT JOIN game ON game.gameId = gameresults.gameId
/ * WHERE gameresults.gameName Is NULL <-- incorrect */
WHERE gameresults.gameId IS NULL;