title: Trigger to copy few columns from table1 to table2 automatically when new data is imported into table1
body: <p>I have a <code>table1</code> with columns (<code>date, field1, field2, field3, field4, field5, field6, field7, field8</code>)</p>
  
  <p>I have another <code>table2</code> with columns (<code>date, field1,someothercolumns, field3, field5, field7, unrelatedcolumns1, someothercolumns2</code>)</p>
  
  <p>Now every time when new data is imported into <code>table2</code>, I also want data from columns (<code>date, field1, field3, field5, field7</code>) from <code>table2</code> to automatically be copied into <code>table1</code> (<code>date, field1, field3, field5, field7</code>).</p>
  
  <p>Missing columns in <code>table1</code> can have null values</p>
  
  <p>Is it possible using trigger or any stored procedures?</p>