sql 语句合并

来源：百度知道 编辑：UC知道 时间：2024/06/15 02:14:17
select A,(B-C) as B1 from 01.DBO.CK WHERE A='0001'
得到数据 A B1
2008 50
select A,sum(D-E)as D1 from 02.DBO.ml group by A order by A
得到数据 A D1
2008 40
请问怎样用一条语句得到: A （B1+D1）

select A,(B-C+(select sum(D-E) from 02.DBO.ml aa where aa.A=bb.A)) as B1 from 01.DBO.CK bb WHERE A='0001'

select x.A,x.B1+y.D1 from

(select A,(B-C) as B1 from 01.DBO.CK WHERE A='0001') x,
(elect A,sum(D-E)as D1 from 02.DBO.ml group by A order by A) y

where x.A=y.A;

select A, sum(B1) from (
select A,(B-C) as B1 from 01.DBO.CK WHERE A='0001'
union
select A,sum(D-E)as B1 from 02.DBO.ml group by A )
group by A

select A,(B-C)+(select sum(D-E) from 02.DBO.ml) as 'B1+D1' from 01.DBO.CK 02.DBO.ml WHERE A='0001'