作业，sql表1和表二的列完全一样，要求表1和表2某列的和

[user0001cn]

表1 和表2的列有 sid sname wuli chinese total,要求表1和表2wuli的得分，sql怎么写，请教各位大虾

[toury]

那不叫列，叫字段

[hookee]

SELECT SUM(a) FROM (SELECT SUM(wuli) AS a FROM 表1 UNION ALL SELECT SUM(wuli) AS a FROM 表2) AS t

[凡夫与俗子]

[Quote=引用 2 楼 hookee 的回复:]
SELECT SUM(a) FROM (SELECT SUM(wuli) AS a FROM 表1 UNION ALL SELECT SUM(wuli) AS a FROM 表2) AS t
[/Quote]
就这个。从表1和表2中求wuli的和 拼接成一个数据集，然后在select这个数据集并sum求和。

[ZSJ_COOL]

是呢或者用 ID in 也可以 后面跟一个 子查询SQL语句！

[good-code]

SELECT SUM(a) FROM (SELECT SUM(wuli) AS a FROM 表1 UNION ALL SELECT SUM(wuli) AS a FROM 表2) AS t
2楼的就可以了，没什么好说的