修改成这样试一下吧:
select a.f1,a,f2 ,ccc
from a,b,(select c.f1 as ccc from c where c.key = a.key) as f3 where a.key = b.key
select a.f1,a,f2 ,ccc
from a,b,(select c.f1 as ccc from c where c.key = a.key) as f3 where a.key = b.key
调试欢乐多
如果是4.1以下的是不支持这样的子查询的。
如果是4.1以下的是不支持这样的子查询的"我确认是这样的。