title: MySQL Removing duplicate columns on Left Join, 3 tables
body: <p>I have three tables, each have a foreign key. When I perform a  join, I get duplicate columns.</p>
  
  <p>Given</p>
  
  <pre><code>mysql&gt; describe Family;
  +---------------+-------------+------+-----+---------+-------+
  | Field         | Type        | Null | Key | Default | Extra |
  +---------------+-------------+------+-----+---------+-------+
  | HEAD_name     | varchar(45) | NO   | PRI |         |       |
  | Family_Size   | int(11)     | NO   |     |         |       |
  | Gender        | char(1)     | NO   |     |         |       |
  | ID_Number     | int(11)     | NO   |     |         |       |
  | DOB           | date        | NO   |     |         |       |
  | Supervisor_ID | int(11)     | NO   | MUL |         |       |
  +---------------+-------------+------+-----+---------+-------+
  6 rows in set (0.00 sec)
  
  mysql&gt; describe SUPERVISOR;
  +-------------------+---------------+------+-----+---------+-------+
  | Field             | Type          | Null | Key | Default | Extra |
  +-------------------+---------------+------+-----+---------+-------+
  | Supervisor_ID     | int(11)       | NO   | PRI |         |       |
  | Supervisor_Name   | varchar(45)   | NO   |     |         |       |
  | Supervisor_Number | decimal(10,0) | NO   |     |         |       |
  | Center_ID         | int(11)       | NO   | MUL |         |       |
  +-------------------+---------------+------+-----+---------+-------+
  4 rows in set (0.00 sec)
  
  mysql&gt; describe CENTER;
  +-----------+-------------+------+-----+---------+-------+
  | Field     | Type        | Null | Key | Default | Extra |
  +-----------+-------------+------+-----+---------+-------+
  | Center_ID | int(11)     | NO   | PRI |         |       |
  | Location  | varchar(45) | NO   |     |         |       |
  +-----------+-------------+------+-----+---------+-------+
  2 rows in set (0.00 sec)
  </code></pre>
  
  <p>My query statement:</p>
  
  <pre><code>SELECT * from Family
     JOIN SUPERVISOR on ( Family.Supervisor_ID = SUPERVISOR.Supervisor_ID)
     JOIN CENTER on (SUPERVISOR.Center_ID = CENTER.Center_ID); 
  </code></pre>
  
  <p>My objective is to get one row of all the columns from the join without duplicate columns.
  So what is the SQL statement syntax that I should use?</p>