SELECT Mate_PBusinessDocNo 采购单号,Mate_PTotalQuantity总计数量,Mate_PTotalTon总计吨数,Mate_PTotalAmount,
SUM(Mate_PDWholeQuantity) 细表数量, SUM(Mate_PDWholeTon) 细表吨数, SUM(Mate_PDAmount) 细表金额
FROM dbo.Mate_Purchasing p -- 采购单
LEFT JOIN dbo.Mate_PurchasingDetail pd ON p.Mate_PCode = pd.Mate_PCode-- 采购明细
GROUP BY Mate_PBusinessDocNo,Mate_PTotalQuantity,Mate_PTotalTon,Mate_PTotalAmount
HAVING Mate_PTotalQuantity <> SUM(Mate_PDWholeQuantity) OR Mate_PTotalTon <> SUM(Mate_PDWholeTon) OR Mate_PTotalAmount <> SUM(Mate_PDAmount)
OR COUNT(Mate_PDWholeQuantity) = 0 --不存在细表数据的单据
