mysql 查询连接三个表

Question

我有三个表:

players
------
id|name 

teams
-------
id|name 

teams_players
-------------
id|teamID|playerID

我现在想要获取表“players”中的每个条目，其中players.id例如在id为15的团队中。换句话说:我想要获取属于特定团队的每个玩家(例如teamID = 15 )

我尝试加入但失败。

这是我到目前为止得到的:

       "SELECT players.*
        FROM players
        JOIN teams_players
        ON teams_players.teamID = 15 
        GROUP BY players.id"; 

Answer 1

你把这件事想得太复杂了。

select players.*
 from players
 join teams_players
 on players.id = teams_players.playerid
 where teams_players.teamid = 15

JOIN 部分与数字 15 无关。15 是您过滤结果的方式。