a和b表有个同名的字段x
select a1,a.x as x,a4,sum(b1),b2
from a left join b on a3=b3
group by a1,a2,x,b2,b4
9i上查询OK
11g上查询报错 Ora-00918:未明确定义列
后来把group by的x改成a.x就OK了,请问为什么?
9i和11g的区别?
select a1,a.x as x,a4,sum(b1),b2
from a left join b on a3=b3
group by a1,a2,a.x,b2,b4
|