title: sql update multiple columns with multiple conditions
body: <p>I want to update 5 columns from another table.  2 of the column will be up dated from a condition the other 3 will also be update if condition one is true and condition two is true.  is there a way to do this in one statement?</p>
  
  <pre><code>update tableNew
  set 
  column1 = t1.column1
  column2 = t1.column2
  
  column3 = t1.column3
  column4 = t1.column4
  column5 = t1.column5
  where t1.column10 in ('value1','value2') 
  
  from tableOld t1
  where t1.column8 is null
  </code></pre>
  
  <p>i hope you can understand what I need from this example if not I can try and give more!!</p>