mysql错误内连接

Question

我使用了类似这样的查询

select a.email,b.vuid 
from user a
,inner join group b on a.uid = b.uid 
where a.email='xx@xx.de' and a.kid=1 and b.vid=29 
limit 1

但我总是遇到这个错误。

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'inner join group b on a.uid = b.uid where a.email='xx@xx.de' at line 1

我认为这是因为内部连接，但我真的不知道......有人可以帮助我吗？

Answer 1

删除 from user a 之后的 ,。

您的查询应该是:

select a.email,b.vuid
from user a
inner join group b
on a.uid = b.uid
where a.email='xx@xx.de'
    and a.kid=1 
    and b.vid=29
limit 1