title: insert value in a table from another table
body: <p>Plase someone help me in adding a value from table to another table in <code>sql server</code></p>
  
  <p>I have one table with columns <code>(reserve,name,price)</code></p>
  
  <p>and another table with columns <code>(name,price)</code></p>
  
  <p>i want to insert into <code>table1(price)</code> value from <code>table2(price)</code></p>