select
SUM (cp.TotalAmount) as totalPaymentamount,
lvl4.SubSubsidaryAccountName as account1
from
TBLCPVMaster cp,TBLLevel4 lvl4
where
cp.SubSubsidaryAccountId = lvl4.SubSubsidaryAccountCode
group by
lvl4.SubSubsidaryAccountName
select
SUM (cr.TotalAmount) as totalReciveamount,
lvl4_2.SubSubsidaryAccountName as account2
from
TBLCRVMaster cr, TBLLevel4 lvl4_2
where
cr.SubSubsidaryAccountId = lvl4_2.SubSubsidaryAccountCode
group by
lvl4_2.SubSubsidaryAccountName
结果表应包含4列...请帮助
提前致谢
您确实应该开始使用ANSI-92中的连接语法。已经25年了。
with Payments as
(
select SUM (cp.TotalAmount) as totalPaymentamount
, lvl4.SubSubsidaryAccountName as account1
from TBLCPVMaster cp
join TBLLevel4 lvl4 on cp.SubSubsidaryAccountId = lvl4.SubSubsidaryAccountCode
group by lvl4.SubSubsidaryAccountName
)
, Receipts as
(
select SUM (cr.TotalAmount) as totalReciveamount
, lvl4_2.SubSubsidaryAccountName as account2
from TBLCRVMaster cr
join TBLLevel4 lvl4_2 on cr.SubSubsidaryAccountId = lvl4_2.SubSubsidaryAccountCode
group by lvl4_2.SubSubsidaryAccountName
)
select p.totalPaymentAmount
, p.account1
, r.totalReciveAmount
, r.account2
from Payments p
cross join Receipts r
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句