全部分数送上,技术性高,高手请进,数据库嵌套语句

select 姓名,sum(积分) as 合计积分 from
(
select 姓名,积分,课程 from 表1
union all
select 姓名,积分,课程 from 表2
)t
where 课程='语文'
group by 姓名
order by 姓名

select a.Name,a.Point+b.Point from t1 as a
inner join t2 as b
on a.Name = b.Name
order by 1
试试这个行不

select isnull(a.姓名,b.姓名) ,a.积分+b.积分 as 合计积分 from
(select 姓名, sum(积分) as 积分 from 表1 where 课程='语文' group by 姓名) a left join
(select 姓名, sum(积分) as 积分 from 表2 where 课程='语文' group by 姓名) b
on a.姓名=b.姓名 order by a.姓名
-----
union all 在一些数据库里不能用！

一楼正解