title: MYSQL JOIN multiple tables, avoiding duplicate entries on duplicate rows
body: <p>I would like to SELECT JOIN three table.
  Two of them have unique entries but one may have multiple rows for the unique identifier from my main table.
  I would like to get multiple rows in my query result if in table three are multiple entries but I would like to get only differing values und no duplicates from row before.
  For a simple example it should look like this:</p>
  
  <p>Table user:</p>
  
  <pre><code>+----------+-----------+--------------+
  | user_id  | user_name | email        |
  +----------+-----------+--------------+
  | 1        | name1     | one@ex.tld   |
  | 2        | name2     | two@ex.tld   |
  | 3        | name3     | three@ex.tld |
  +----------+-----------+--------------+
  </code></pre>
  
  <p>Table info:</p>
  
  <pre><code>+----------+---------+--------+
  | info_id  | user_id | info   |
  +----------+---------+--------+
  | 1        | 1       | text1  |
  | 2        | 2       | text2  |
  | 3        | 3       | text3  |
  +----------+---------+--------+
  </code></pre>
  
  <p>Table address:</p>
  
  <pre><code>+------------+--------+----------------+
  | address_id | user_id| address_field1 |
  +------------+--------+----------------+
  | 1          | 1      | City A         |
  | 2          | 1      | City B         |
  | 3          | 2      | City C         |
  | 4          | 2      | City D         |
  | 5          | 2      | City E         |
  | 6          | 3      | City F         |
  +------------+--------+----------------+
  </code></pre>
  
  <p>My actual query is: 
  SELECT u.user_name, u.email, i.info, a.address_field1
  FROM user u
  INNER JOIN info i ON (u.user_id = i.user_id)
  INNER JOIN address a ON (u.user_id = a.user_id);</p>
  
  <p>^^I tried LEFT JOIN and JOIN as well without success.</p>
  
  <p>Query result:</p>
  
  <pre><code>+-----------+--------------+--------+----------------+
  | user_name | email        | info   | address_field1 |
  +-----------+--------------+--------+----------------+
  | name1     | one@ex.tld   | text1  | City A         |
  | name1     | one@ex.tld   | text1  | City B         |
  | name2     | two@ex.tld   | text2  | City C         |
  | name2     | two@ex.tld   | text2  | City D         |
  | name2     | two@ex.tld   | text2  | City E         |
  | name3     | three@ex.tld | text3  | City F         |
  +-----------+--------------+--------+----------------+
  </code></pre>
  
  <p>Query result I try to achieve:</p>
  
  <pre><code>+-----------+--------------+--------+----------------+
  | user_name | email        | info   | address_field1 |
  +-----------+--------------+--------+----------------+
  | name1     | one@ex.tld   | text1  | City A         |
  |           |              |        | City B         |
  | name2     | two@ex.tld   | text2  | City C         |
  |           |              |        | City D         |
  |           |              |        | City E         |
  | name3     | three@ex.tld | text3  | City F         |
  +-----------+--------------+--------+----------------+
  </code></pre>
  
  <p>I know this is possible but I don't know how and I'm not sure what I should search for. Can someone put me in the right direct?</p>