参见英文答案 >
MySQL unknown column in ON clause 3
我有以下MySQL查询:
SELECT posts.id, posts.name, LEFT(posts.content, 400), posts.author, posts.date, users.display_name,
GROUP_CONCAT(tags.tag ORDER BY tag_linking.pid ASC SEPARATOR ",") update_tags
FROM posts, tag_linking, tags
INNER JOIN `users`
ON posts.author=users.id;
WHERE tag_linking.pid = posts.id
AND tags.id = tag_linking.tid
ORDER BY posts.date DESC
哪个,你可以看到,连接三个表等等.无论如何,问题是它给出一个错误:
ERROR CODE:
SQL Error (1054): Unknown column 'posts.author' in 'on clause'
即使在另一个页面上使用更简单的查询工作:
SELECT posts.id, posts.name, LEFT(posts.content, 400), posts.author, posts.date, users.display_name FROM `posts`
INNER JOIN `users`
ON posts.author=users.id
有人有什么想法为什么会发生这种情况?谢谢你的帮助.