在PHP查询中加入3个表
好吧,出于某种原因,我无法正确地使用PHP和MySQL连接3个表。我的查询处理2,但与3它不会。在PHP查询中加入3个表
select users.username,
users.ID,
users.currentTime,
users.gender,
user_ranks.likes as likes,
user_ranks.disslikes as diss,
profiles.img_url as URL
from users
inner join profiles,
user_ranks on users.ID = profiles.userID LIMIT 1
你需要加入两个表与ON
条款:
select users.username,
users.ID,
users.currentTime,
users.gender,
user_ranks.likes as likes,
user_ranks.disslikes as diss,
profiles.img_url as URL
from users
inner join profiles on users.ID = profiles.userID
inner join user_ranks on user_ranks.ID = profiles.userID
LIMIT 1
嗯,这是有道理的,我不知道我不得不加入2次,全力阻滞哈哈。感谢队友,非常感谢。只要*允许我将它标记为正确的答案! –
很高兴能帮到你! – wogsland
SELECT users.username,
users.ID,
users.currentTime,
users.gender,
user_ranks.likes as likes,
user_ranks.disslikes as diss,
profiles.img_url as URL
FROM users
INNER JOIN profiles
on users.ID = profiles.userID
INNER JOIN user_ranks
on user_ranks.ID = profiles.userID
LIMIT 1
太多'LIMIT's ... – wogsland
SELECT
users.username,
users.ID,
users.currentTime,
users.gender,
user_ranks.likes as likes,
user_ranks.disslikes as diss,
profiles.img_url as URL
FROM users
INNER JOIN profiles ON users.ID = profiles.userID
INNER JOIN tbl_3 ON users.col = tbl_3.fk
LIMIT 1
你需要做的每个表的加入。例如:
select users.username,
users.ID,
users.currentTime,
users.gender,
user_ranks.likes as likes,
user_ranks.disslikes as diss,
profiles.img_url as URL from users
inner join profiles on users.ID = profiles.userID
inner join user_ranks on users.ID= user_ranks.ID LIMIT 1
您只有一个'on'。第三张表如何加入? – chris85