还有一个问题好久没有解决。帮我看看好吗?http://expert.csdn.net/Expert/topic/1887/1887698.xml?temp=.2313654
http://expert.csdn.net/Expert/topic/1893/1893992.xml?temp=.61047我用select sum(fs) as getsum
from (select sum(一年级分数) as fs from tablename where 条件
union
select sum(二年级分数) from tablename where 条件
union
select sum(三年级分数) from tablename where 条件)
也不行啊。
http://expert.csdn.net/Expert/topic/1893/1893992.xml?temp=.61047我用select sum(fs) as getsum
from (select sum(一年级分数) as fs from tablename where 条件
union
select sum(二年级分数) from tablename where 条件
union
select sum(三年级分数) from tablename where 条件)
也不行啊。
from (select sum(一年级分数) as fs from tablename where 条件
union
select sum(二年级分数) from tablename where 条件
union
select sum(三年级分数) from tablename where 条件) a
token:select
line Number:2