title: SQL Merge multiple tables with different columns into one
body: <p>I need to create one master table from 5 tables, the difficulty is that the same column across the tables may have a different name. so for instance</p>
  
  <p>For simplicity I`m just going to give an example for 2 tables</p>
  
  <pre><code>+----+----+
  | 1  | 2  |
  +----+----+
  | PO | P  |
  | VE | V  |
  | TE | TE |
  | LO | LO |
  | IN |    |
  | D  |    |
  | X  |    |
  | Y  |    |
  |    | A  |
  |    | B  |
  |    | C  |
  +----+----+
  </code></pre>
  
  <p>so as you can see PO doesn`t have the same column name as the corresponding value in table 2 yet they are the same record. I need to aggregate these 2 tables into one master. </p>
  
  <p>What I did was began with the table that has the most repeated columns and I am trying to merge the other tables into it. When there is a column only found on one table I want the other fields to display null. Also I don't want any duplicates. Hope someone can help me out!</p>
  
  <p>Cheers</p>