title: insert into table1 from table2 with condition
body: <p>I have two tables, and I want to insert data in one of the new column (Orders) of table1 from table2. Any help please, below code is not working </p>
  
  <pre><code>Insert into Table1 (Orders)
    Select (orders) from table2,
    Where table1.id=table2.id
  </code></pre>