从一开始我就使用这段代码从表A(类别)转到表B(连接)
$query = "SELECT *
FROM joined
INNER JOIN category
ON joined.categoryid = category.categoryid
现在我已经创建了第三个名为'userticket'的表。从"userticket"表中,我有一个名为"jid"的列,这是连接表中名为"jid"的列的外键。基本上,这对我来说很容易显示' id'上的'usertickets'表作为数字,但我如何连接表,这样我就可以从表A到B到C,这样我就可以从表A(类别)到C (userticket)的信息?
再举一个例子
SELECT *
FROM joined
INNER JOIN category
ON joined.categoryid = category.categoryid
INNER JOIN usertickets
ON usertickets.jid = joined.jid
试试下面的代码:
SELECT *
FROM joined j
INNER JOIN category c ON (c.categoryid = j.categoryid)
INNER JOIN userticket u ON (u.jid = j.jid);
你可以删除别名,但我认为最好得到一个清晰的代码