MySQL 连接查询 - 不是唯一的表/别名

Question

这个有什么问题？我收到错误 #1066 - 不是唯一的表/别名:'v'

SELECT v.newsid AS identifier, j.createdate AS DATE, j.newstext AS TEXT, j.uuid AS user, j.flags AS fcount, j.votes AS vcount, j.authornick AS nick 
FROM votes v 
INNER JOIN news v ON j.newsid = v.newsid GROUP BY v.newsid ORDER BY COUNT( v.newsid )   
LIMIT 20

Answer 1

您不能多次使用同一个表别名。您将 v 与 votes 和表 news 相关联。

将您的查询和别名引用更改为类似

SELECT .....
FROM votes v 
INNER JOIN news n ON ....
               ^^^ <=== Change this to something else