两个表数据相加！
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