select *
from ( select
sellProject.FName_l2 projectName,sum(revBillEntry.frevAmount) fappAmount,'y'+convert(varchar, month (revBill.fbizdate))dateMonth ,YEAR(revBill.fbizdate)dateYear
from T_TEN_TenancyBill tenancy
left join T_SHE_SellProject sellProject
on tenancy.fsellprojectid = sellProject.fid
left join T_FDC_ContractType contractType
on contractType.fid = tenancy.CFContypeID
left join T_TEN_TenancyRoomPayListEntry tre
on tre.ftenbillid = tenancy.fid
left join T_BDC_FDCReceivingBillEntry revBillEntry
on revBillEntry.frevlistid = tre.fid
left join T_BDC_FDCReceivingBill revBill
on revBillEntry.fheadId = revBill.fid
left join T_SHE_MoneyDefine define
on define.FID = revBillEntry.FMoneyDefineID
where year(revBill.fbizdate) ='2018'
and revBill.fbillStatus in ('12', '14')
and revBIll.FRevBillType in ('gathering','transfer','refundment')/*收款*/
and define.FName_l2 in ( '租金')
and contractType.fname_l2 in
('招商租赁合同','租赁终止合同','招商代理合同','宣传服务合同','租赁法律事务处理合同')
group by sellProject.FName_l2 ,month (revBill.fbizdate),YEAR(revBill.fbizdate)
) as C left join
(select sellProject.FName_l2, sum(payList.fappAmount) wnys
from T_TEN_TenancyBill tenancy
left join T_SHE_SellProject sellProject
on tenancy.fsellprojectid = sellProject.fid
left join T_FDC_ContractType contractType
on contractType.fid = tenancy.CFContypeID
left join T_TEN_TenancyRoomEntry roomEntry
on roomEntry.ftenancyId = tenancy.fid
left join T_TEN_TenancyRoomPayListEntry payList
on paylist.ftenRoomId = roomEntry.fid
left join T_SHE_MoneyDefine define
on define.FID = payList.FMoneyDefineID
where year(payList.fstartdate) = '2018'
and define.FName_l2 in ('租金')
and tenancy.ftenancyStateDisplay not in('Submitted','Audited')
and contractType.fname_l2 in
('招商租赁合同','租赁终止合同','招商代理合同','宣传服务合同','租赁法律事务处理合同')
group by sellProject.FName_l2) as B on C.projectName = B.FName_l2
PIVOT(sum(fappAmount) FOR dateMonth IN([y1],[y2],[y3],[y4],[y5],[y6],[y7],[y8],[y9],[y10],[y11],[y12])) AS T
查出的表如图
怎么把每行的数据加起来，在前面wnys后面写一列bnys，显示在里面，有大佬吗，帮帮忙，谢谢