title: Insert Data From One Table to Another Table with default values
body: <p>The following query works fine but I have a different requirement.</p>
  
  <p>My requirement is as follows.
  I have table1 and table2, table1 contains 5 columns and table2 contains 3 columns. Now, we need to pull data from table2 and insert into table1. Here in table2 contains only 3 columns and table1 contains 5 columns. So the rest should insert with some default values.</p>
  
  <p>Could someone help me how to write a query for this.</p>