尝试类似以下的操作（假设字段名称）。它将显示玩家的姓名，比赛的matchId以及他们是否在该比赛中得分：)。
SELECt p.Name as 'Player Name', m.matchId as 'Match Id',CASE s.scorerId WHEN ISNULL(S.SCORERID,0) THEN 'YES' ELSE 'NO' END as 'Scored?',s.name as 'Scorer Name' --as requested from commentFROM match mINNER JOIN player p ON p.player_id IN (m.playerID1, m.playerID2, m.playerID3)LEFT JOIN scorer s ON s.matchId = m.matchId AND s.player_id IN (m.playerID1, m.playerID2, m.playerID3)
看到这个SQLFiddle HERE
