title: SQL Query to include 3rd colum in WHERE Exist CLAUSE
body: <p>How can i include the <code>SUM(tonnage_adjusted)</code> of a column in <code>DeliverTons</code> into this sql query to produce my 3 column of values needed. </p>
  
  <pre><code>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
  </code></pre>