假设我有这样的表格:
表 NUM1 :
+----+-----+
| no | val |
+----+-----+
| 1 | 10 |
| 2 | 15 |
| 3 | 20 |
+----+-----+
表 num2:
+----+-----+
| no | tot |
+----+-----+
| 1 | 15 |
| 2 | 20 |
| 3 | 25 |
+----+-----+
所以,我想在单个查询中选择表 nu1.val 和表 num2.tot 的总和值
Select sum(a.val),sum(b.tot) from num1 a, num2 b
查询不起作用请帮忙
将这 2 个表连接到 No 列上,然后求和。
select sum(n1.val),sum(n2.tot) from num1 n1 join num2 n2 on n1.no=n2.no
选择 Sum(((从 table_name 中选择 sum(col_name(+(从 table_name 中选择 sum(col_name(((;测试者:- 拉胡尔·潘瓦尔
select max(num1) ,max(num2) from (
select sum(val) as num1,0 from num1
union
select 0,sum(tot) as num2 from num2)
感谢您的所有回复。 但是,我已经想通了
从 num1n1 num2 n2 中选择 sum(distinct n1.val(,sum(distinct n2.tot(