开发者

Error from mysql query, trying to join tables

Can anyone see why this code is returning an error?

    "SELECT
a.widget_id,
c.additional_widget_i开发者_如何学Cd
FROM
exp_widgets AS a,
INNER JOIN exp_widget_additional AS c ON a.entry_id = c.additional_entry_id
WHERE
a.template = 3
AND
c.additional_template_id = 3
AND
(a.entry_id = 6 OR c.additional_entry_id = 6)
";

Any help appreciated.


You have a rogue comma:

...
exp_widgets AS a,
INNER JOIN exp_widget_additional`
...

should be

...
exp_widgets AS a
INNER JOIN exp_widget_additional
...
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜