sql 查询结果相加
SELECT count(*) FROM sale_1110 where salerid ="01022";
SELECT count(*) FROM sale_1109 where salerid ="01022";
SELECT count(*) FROM sale_1108 where salerid ="01022";
SELECT count(*) FROM sale_1107 where salerid ="01022";
如将这几结果相加
例子：
select a.snum1 + b.snum2 from
(select sum(num1) snum1 from table1)a ,
(select sum(num2) snum2 from table2)b
这样就能把a表和b表的结果相加看
(select sum(num1) snum1 from table1)a 用于统计table1表中num1字段的总和 其结果作为表a
(select sum(num2) snum2 from table2)b 用于于统计table2表中num2字段的总和 其结果作为表a
select a.snum1 + b.snum2 将a表和b表中的sum1和sum2相加
这样既可做查询结果相加本回答被网友采纳
SELECT count(*) col FROM sale_1110 where salerid ="01022" union all
SELECT count(*) col FROM sale_1109 where salerid ="01022" union all
SELECT count(*) col FROM sale_1108 where salerid ="01022" union all
SELECT count(*) col FROM sale_1107 where salerid ="01022")追问
select sum(col) from (
SELECT count(*) col FROM sale_1110 where salerid ="01022" union all
SELECT count(*) col FROM sale_1109 where salerid ="01022和select sum(col) from (
SELECT count(*) col FROM sale_1110 where salerid ="01021" union all
SELECT count(*) col FROM sale_1109 where salerid ="01021" union all
可以整编成，结果是二列
??
追问条件salerid 不一样，不想一个个查，可以一个语句查出来吗？ 当只是salerid一样的求和
追答如果数据量大,建议使用索引.
select count(salerid ) from (
SELECT salerid FROM sale_1110 union all
SELECT salerid FROM sale_1109 union all
SELECT salerid FROM sale_1108 union all
SELECT salerid FROM sale_1107) where salerid ="01022"
(
SELECT qty=count(*) FROM sale_1110 where salerid ="01022"
Union All
SELECT qty=count(*) FROM sale_1109 where salerid ="01022"
Union All
SELECT qty=count(*) FROM sale_1108 where salerid ="01022"
Union All
SELECT qty= count(*) FROM sale_1107 where salerid ="01022"
) a
