590
社区成员
发帖
与我相关
我的任务
分享
select TD.OwnerName,TD.CltName,sum(TD.JHSL) JHSL,sum(TD.JHSL2) JHSL2,TD.JHRQ,sum(TD1.LineSumFC) LineSumFC
From ZZXSJH TM
LEFT JOIN ZZXSJHA TD on TD.DocEntry=TM.DocEntry
LEFT JOIN SAOrdA TD1 on TD1.DocEntry
LEFT JOIN SAord TM1 ON TM1.DocEntry
Where TM1.DocDate>=TD.JHRQ
Group by TD.OwnerName,TD.JHRQ,TM1.CrdName,TD.CltName
ZZXSJHA表,SAOrdA表在你上面的图片中都没有啊,还有,最后两个表怎么都没有关联条件啊
[/quote][/quote]
那就直接用上面两个表连一下就可以啦,搞这么复杂干嘛啊select TD.OwnerName,TD.CltName,sum(TD.JHSL) JHSL,sum(TD.JHSL2) JHSL2,TD.JHRQ,sum(TD1.LineSumFC) LineSumFC
From ZZXSJH TM
LEFT JOIN ZZXSJHA TD on TD.DocEntry=TM.DocEntry
LEFT JOIN SAOrdA TD1 on TD1.DocEntry
LEFT JOIN SAord TM1 ON TM1.DocEntry
Where TM1.DocDate>=TD.JHRQ
Group by TD.OwnerName,TD.JHRQ,TM1.CrdName,TD.CltName
ZZXSJHA表,SAOrdA表在你上面的图片中都没有啊,还有,最后两个表怎么都没有关联条件啊
[/quote]select TD.OwnerName,TD.CltName,sum(TD.JHSL) JHSL,sum(TD.JHSL2) JHSL2,TD.JHRQ,sum(TD1.LineSumFC) LineSumFC
From ZZXSJH TM
LEFT JOIN ZZXSJHA TD on TD.DocEntry=TM.DocEntry
LEFT JOIN SAOrdA TD1 on TD1.DocEntry
LEFT JOIN SAord TM1 ON TM1.DocEntry
Where TM1.DocDate>=TD.JHRQ
Group by TD.OwnerName,TD.JHRQ,TM1.CrdName,TD.CltName
ZZXSJHA表,SAOrdA表在你上面的图片中都没有啊,还有,最后两个表怎么都没有关联条件啊
SELECT DISTINCT TD.OwnerName,
TD.CltName,
SUM(TD.JHSL) OVER(PARTITION BY TD.JHRQ,TM1.CrdName) JHSL,
SUM(TD.JHSL2) OVER(PARTITION BY TD.JHRQ,TM1.CrdName) JHSL2,
TD.JHRQ,
SUM(TD1.LineSumFC) OVER(PARTITION BY TD.JHRQ,TM1.CrdName) LineSumFC
FROM ZZXSJH TM
LEFT JOIN ZZXSJHA TD
ON TD.DocEntry = TM.DocEntry
LEFT JOIN SAOrdA TD1
ON TD1.DocEntry
LEFT JOIN SAord TM1
ON TM1.DocEntry
WHERE TM1.DocDate >= TD.JHRQ
用over(partition by )
select max(TD.OwnerName),max(TD.CltName),sum(TD.JHSL) JHSL,sum(TD.JHSL2) JHSL2,TD.JHRQ,sum(TD1.LineSumFC) LineSumFC
From ZZXSJH TM
LEFT JOIN ZZXSJHA TD on TD.DocEntry=TM.DocEntry
LEFT JOIN SAOrdA TD1 on TD1.DocEntry
LEFT JOIN SAord TM1 ON TM1.DocEntry
Where TM1.DocDate>=TD.JHRQ
Group by TD.JHRQ,TM1.CrdName