34,575
社区成员
发帖
与我相关
我的任务
分享
select enddate,payTAmt=sum(payTAmt),sumprice=sum(sumprice)
,diff=isnull(sum(payTAmt),0)-isnull(sum(sumprice),0)
from (
select enddate=cast(enddate as date),payTAmt,sumprice=0
from 订单表
union all
select enddate=cast(tmdate as date),payTAmt=0,sumprice
from 金库表表
) a
group by enddate