php - 如何成功完成这条INSERT JOIN WHERE SQL语句？

Question

我希望将各自表中的 community_id 和 player_id 插入到表 community_players 中；满足以下条件的“社区”和“用户”:

users.user_email AND communities.admin = 'steve.downs@gmail.com'和communities.code = 'HX99F9'

这就是我目前所拥有的......

INSERT INTO TABLE community_players(community_id，player_id)
FROM TABLE 社区
JOIN TABLE 用户
编号
WHERE users.user_email = 'steve.downs@gmail.com'
AND communities.admin = 'steve.downs@gmail.com'
AND communities.code = 'HX99f9'

这些是有问题的 3 个表:

用户
编号 |用户邮箱 |用户密码 |用户名

社区
编号 |姓名 |代码 |管理员

社区玩家
社区编号 | player_id

Answer 1

应该是这样的:

INSERT INTO community_players (community_id, player_id)
SELECT communities.id, users.id
FROM communities INNER JOIN users ON communities.admin = users.user_email
WHERE users.user_email = 'steve.downs@gmail.com'
AND communities.code = 'HX99f9'