日期:2014-05-18  浏览次数:20665 次

在线等..急!..求一sql语句
各位侠:

现有如下两个查询结果

select   count(*)   as   Acnt,sum(credit)   as   Acredit   from   A

select   count(*)   as   Bcnt,sum(credit)   as   Bcredit   from   B

我现在要得到  
select   Acnt+Bcnt   as   ABcnt   ,Acredit+Bcredit   as   ABcredit

求一个sql语句将其实现

说明:A,B两表结构不同,也无关联索引字段

------解决方案--------------------
select ABcnt=sum(ABcnt),ABcredit=sum(ABcredit) from
(
select count(*) as ABcnt,sum(credit) as ABcredit from A
union all
select count(*) as ABcnt,sum(credit) as ABcredit from B
)a
------解决方案--------------------
看样了不急,用join也可以,不如上边好,但可同时得到另个的4个量
select Acnt+Bcnt as ABcnt ,Acredit+Bcredit as ABcredit from
(select count(*) as Acnt,sum(credit) as Acredit from #aa)aa left join
(select count(*) as Bcnt,sum(credit) as Bcredit from #bb)bb on 1=1