MySQL:INNER JOIN 在这个语句中会是最有效的吗？

Question

下面的 MySQL 语句需要很长时间才能执行，我想是因为我正在使用 gameId IN。

我认为最有效的方法是使用 INNER JOIN，但我是 MySQL 的新手，我不会想出 INNER JOIN 语句.你能帮帮我吗？如果有比 INNER JOIN 更有效的方法，我想使用它，只是不确定是否有。

需要更高效的语句:

SELECT championId
FROM match_up WHERE
gameId IN
(
    SELECT gameId
    FROM match_up 
    GROUP BY gameId
    HAVING SUM(championId IN (19, 23, 40) AND win = 1) = 3
    AND SUM(championId IN (7, 18) AND win = 0) = 2
)

提前感谢您的帮助和知识!

Answer 1

怎么样

SELECT m.championId
FROM match_up m INNER JOIN
(
    SELECT gameId
    FROM match_up 
    GROUP BY gameId
    HAVING SUM(championId IN (19, 23, 40) AND win = 1) = 3
    AND SUM(championId IN (7, 18) AND win = 0) = 2
) s ON m.gameID = s.gameID

看看Row Subqueries之间的区别和 Subqueries in the FROM Clause