title: An aggregate may not appear in the set list of an UPDATE statement (UPDATE)
body: <p>I suspect this issue is something to do with the MIN statement but not sure how to fix it:</p>
  
  <pre><code>UPDATE t1
  
  SET t1.PrintDate = MIN(t2.[Print Date])
  
  FROM [Data Checking].[dbo].[MonthlyReads] t1
  
  INNER JOIN [Data Checking].[dbo].[BILLWINDOWS] t2
  ON t1.MRU = t2.[MR Unit]
  
  WHERE t2.[Print Date] &gt; t1.[ReadingDate]
  </code></pre>
  
  <p>Thanks for any assistance.</p>