title: Need to create stored procedure to copy data from multiple tables to one table
body: <p>I only have experience in creating simple custom tables and I haven't done stored procedures before. I would like to know how to create a stored procedure to copy data from multiple tables into one single table. </p>
  
  <p>There are four tables (and a total of 6 columns in these 4 tables) from which I have to copy data to my Main table. </p>
  
  <pre><code>Table 1 - C1, C2 = Main table - C1, C2                  
  Table 2 - C1, C2 = Main table - C3, C4           
  Table 3 - C1, C2 = Main table - C5, C6          
  Table 4 - C1, C2 = Main table - C7, C8
  </code></pre>
  
  <p>This way my Main table will have a total of 8 columns with data from other tables, and 4 columns with time-stamp, serial number, and such.   </p>
  
  <p>What would be the best way to approach this? </p>