SQL查询以在存在子句中包含第三哥伦布

Question

如何将DeliverTons中的列的SUM(tonnage_adjusted)包括在此SQL查询中，以产生我所需的3列值。

SELECT DISTINCT CROP_CLASS As Opened,SUM(ACREAGE) AS SumofAcreage
From CaneParcel
WHERE EXISTS (SELECT * FROM DeliveryTons WHERE CaneParcel.FIELD_ID = DeliveryTons.parcel_id AND parcel_status = 1) 
Group By CROP_CLASS
Order By SumofAcreage DESC

Answer 1

希望这能解决您的问题

SELECT  
CROP_CLASS As Opened,
SUM(ACREAGE) AS SumofAcreage,
SUM(tonnage_adjusted) AS TonnageAdjusted
FROM 
CaneParcel
INNER JOIN DeliveryTons ON CaneParcel.FIELD_ID = DeliveryTons.parcel_id AND parcel_status = 1
Group By CROP_CLASS
Order By SumofAcreage