首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

两个表数据相加!解决思路

2012-01-09 
两个表数据相加!selectvendorid,sum(totalamt)astotalamtfrom[RECIEVED]groupbyvendoridunionallselectven

两个表数据相加!
select   vendorid,sum(totalamt)   as   'totalamt '   from   [RECIEVED]   group   by   vendorid

union   all

select   vendorid,   sum(totalpay)   as   'totalamt '   from   [cashpay]   group   by   vendorid
我想要的结果是如果vendorid想同的时候,totalamt相加。。。

[解决办法]

select vendorid,sum(totalamt) as 'totalamt ' from
(select vendorid,totalamt from [RECIEVED] group by vendorid
union all
select vendorid, totalpay from [cashpay] group by vendorid)
as tt
group by tt.vendorid

热点排行