title: MySQL Joins of tables with different columns
body: <p>I want to create a table that needs to be a combination of selected columns from three or more tables. I don't have any sample data, just added the columns for explanation.</p>
  
  <p>Table 1</p>
  
  <pre><code>A|B1|C1|D1|E1|F1|G1|H1|I1|J1
  </code></pre>
  
  <p>Table 2</p>
  
  <pre><code>A|B2|C2|D2|E2|F2|G2
  </code></pre>
  
  <p>Table 3</p>
  
  <pre><code>A|B3|C3|D3|E3|F3|G3
  </code></pre>
  
  <p>Resultant New table must have</p>
  
  <pre><code>A|B1|E1|F1|G1|J1|C2|D2|G2|B3|D3|F3
  </code></pre>
  
  <p>I'm not sure if I need to use a FULL JOIN or use UNIONS. 
  Each of these tables contain more than 400,000 rows. Any help here on what query needs to be included would be really helpful. </p>