求助大神:三张表查询问题
三张表相同字段为订单编号(cSoCode),现需要将表SA_ReturnsApplyDetail中的(iSum)字段求和另两张表查询的结果相连接,效果要求如下图:
现有代码:
一.表:SA_ReturnsApplyDetail
SELECT cSoCode as 订单编号,sum(iSum)as 退货金额 FROM SA_ReturnsApplyDetail as R
group by cSoCode
二.表:SO_SODetails
表:SO_SOMain
select M.cSoCode as 订单编号, M.cCusCode as 客户编码,cSTCode as 销售类型 ,SUM(D.iNatSum) as 成品销售金额
from
SO_SODetails as D ,SO_SOMain as M
where M.cSOCode=D.cSOCode and cSTCode='01' and M.cSoCode='XSDD19071900001'
group by M.cSOCode, M.cCusCode ,cSTCode