一条查询语句,疑惑,在线等候

极品红狼

mysql> select a.userId from user a,(select distinct aa.userId from userGroups aa
left join workSumup bb on(aa.userId=bb.userId) where aa.polity=3 and bb.userId
is null) b where a.unitId=1 and a.userId=b.userId;

提示我如下错误:

ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'select disti
nct aa.userId from userGroups aa left join workSumu

难道MYSQL不支持在from后写select语句么?

zhanglyu

MYSQL不支持子查询！！

黄叶

如题！