title: SQL Server Update with group by
body: <pre><code> insert into tableA (column1) 
   select min(tableC.column1)
   from tableB 
   inner join tableC on (tableC.coumn2 = tableB.column1
   and tableB.column2 = tableA.column2) 
   group by tableA.column2
  </code></pre>
  
  <p>How would I change the above to a update with group by instead of insert with group by based on the criteria <code>tableB.column2 = tableA.column2</code> ?</p>
  
  <p>Note that I am using <code>SQL SERVER 2008.</code> </p>