title: Merging Several Data Sets in MYSQL
body: <p>I have a database in mysql with several different tables I would like to create one table.</p>
  
  <p>Three of the the tables (A,B,C) have the same primary key and the last has a different primary key. So it might look like</p>
  
  <h2>Table A</h2>
  
  <h2>ID | Phone| Address</h2>
  
  <hr>
  
  <h2>Table B</h2>
  
  <h2>ID| WorkPhone | Phone | Address</h2>
  
  <hr>
  
  <h2>Table C</h2>
  
  <h2>ID| Phone| Work_Address| WorkPhone</h2>
  
  <p>The biggest problem is that some of the information might be different despite the same ID. (So ID "Person1" might have two different phone numbers in the column "Phone" in the three tables.</p>
  
  <p>For the first three tables, I'm trying to map them together but having problem with my syntax in MYSQL.</p>
  
  <p>Here is what I have so far.</p>
  
  <pre><code>create table Total_Finance(
  
  select combined_csv.*, finance.*, total_contribution.*
  
  join
  
  where combined_csv.id == finance.id
  
  inner join 
  where total_contribution.nationbuilder_id == combined_csv.nationbuilder_id
  
  inner join 
  where total_contribution.nationbuilder_id == finance.nationbuilder_id
  
  
  );
  </code></pre>