根据销售订单汇总销售交货数量
SELECT T0.[BaseEntry], T0.[BaseLine], SUM(T0.[Quantity]) AS 'QTY'
FROM DLN1 T0
GROUP BY T0.[BaseEntry], T0.[BaseLine]
应用于销售订单表，示例销售订单行表为T1
例句
LEFT JOIN (
SELECT T0.[BaseEntry], T0.[BaseLine], SUM(T0.[Quantity]) AS 'QTY'
FROM DLN1 T0
GROUP BY T0.[BaseEntry], T0.[BaseLine]
) TS
ON TS.[BaseEntry] = t1.docentry
AND TS.[BaseLine] = T1.[LineNum]声明：欢迎来到五六零学院。
