select vendorid,sum(totalamt) as 'totalamt' from [RECIEVED] group by vendoridunion allselect vendorid, sum(totalpay) as 'totalamt' from [cashpay] group by vendorid
我想要的结果是如果vendorid想同的时候,totalamt相加
我想要的结果是如果vendorid想同的时候,totalamt相加
解决方案 »
- asp,net 静态化 附带链接问题
- 关于多表查询分页的问题(进来看看,别小看这个问题!)
- 请问startIndex不能大于字符串长度的问题
- Petshop的功能
- design视图不能用
- 加载时显示“正在加载,请稍后...的提示,等页面内容加载完毕,提示自动消失的例子。非AJAX!!!请使用DIV+JS
- vs2005里面是不是没有datagrid?
- 帮忙给个ajax.net + json 的例子,谢谢
- webservice发布在iis上不稳定
- 请问如何在客户端用脚本的方式,在用户点击时取得当前树结点的value值,并保存在一个Session 变量里?
- 开发模板化自定义控件(templated custom control)时遇到的难题
- 请问,如何获取文件的绝对路径?
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
select vendorid,sum(totalamt) as 'totalamt' from
(select vendorid,totalamt from [RECIEVED]
union all
select vendorid, totalpay from [cashpay] )
as tt
group by tt.vendorid
改怎么写呢??
sum(totalamt) as 'totalamt' from
(select vendorid,totalamt from [RECIEVED]
union all
select vendorid, totalpay from [cashpay] )
as tt
group by tt.vendorid