SELECT *
FROM ( ( MJN_VL06 AS a
LEFT JOIN MJN_Sku ON a.Material = MJN_Sku.SkuCode
)
LEFT JOIN ( SELECT SalesDocument ,
ShippingConditions ,
PurchaseOrderNumber ,
SpecialHandling ,
EDIWALPOText ,
SalesDocumentType
FROM MJN_VA05N
GROUP BY SalesDocument ,
ShippingConditions ,
PurchaseOrderNumber ,
SpecialHandling ,
EDIWALPOText ,
SalesDocumentType
) AS b ON a.PurchasingDocument = b.SalesDocument
)
LEFT JOIN MJN_Carrier ON ( a.ShippingReceiving = MJN_Carrier.ShipFromID )
AND ( a.ShipToParty = MJN_Carrier.ShipFromCode )
上面代碼正確執行,把下面加上去就報錯
LEFT JOIN ( SELECT Delivery ,
SUM(TotalWeight) AS SumTotalWeight ,
SUM(Volume) AS SumTotalVolume ,
SUM(DeliveryQuantity) AS SUMDeliveryQuantity
FROM MJN_VL06
GROUP BY Delivery)AS e ON (a.Delivery = e.Delivery)
SELECT *
FROM ( ( MJN_VL06 AS a
LEFT JOIN MJN_Sku ON a.Material = MJN_Sku.SkuCode
)
LEFT JOIN ( SELECT SalesDocument ,
ShippingConditions ,
PurchaseOrderNumber ,
SpecialHandling ,
EDIWALPOText ,
SalesDocumentType
FROM MJN_VA05N
GROUP BY SalesDocument ,
ShippingConditions ,
PurchaseOrderNumber ,
SpecialHandling ,
EDIWALPOText ,
SalesDocumentType
) AS b ON a.PurchasingDocument = b.SalesDocument
)
LEFT JOIN MJN_Carrier ON ( a.ShippingReceiving = MJN_Carrier.ShipFromID )
AND ( a.ShipToParty = MJN_Carrier.ShipFromCode )
LEFT JOIN ( SELECT Delivery ,
SUM(TotalWeight) AS SumTotalWeight ,
SUM(Volume) AS SumTotalVolume ,
SUM(DeliveryQuantity) AS SUMDeliveryQuantity
FROM MJN_VL06
GROUP BY Delivery)AS e ON (a.Delivery = e.Delivery)
uj5u.com熱心網友回復：
問題已經解決!!轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/95231.html
標籤：Access