title: How do I insert values from one table into another table?
body: <p>I have 2 tables, Table A and Table B. I am inserting a value from Table B to Table A. 
  Table A has Column (Key,ID,Name,LOB,a,b,c,d,e,f). Table B has Column (Key,ID,Name,LOB,a,b,c,d,Group). Now I have statements like this,</p>
  
  <pre><code>Insert ##Table A
  (Key,
  ID,Name,LOB,a,b,c
  )
  
  Select
  Key,
  ID,Name,LOB,a,b,c)
  From Table B where Key = "blah"
  </code></pre>
  
  <p>Now instead of selecting LOB from Table B, I want group column and those values to be inserted in the table A for column "LOB"</p>
  
  <p>How do I do that? </p>