title: MySQL Fetch Result Using Multiple Joins in one query?
body: <p>I have below tables</p>
  
  <p><strong>tbl_user</strong></p>
  
  <pre><code>uid     first_name      last_name       email_id
  1       steve           martin          steve1@gmail.com
  2       mark            lee             mark1@gmail.com
  3       nelson          wise            nelson23@gmail.com
  </code></pre>
  
  <p><strong>tbl_tier</strong></p>
  
  <pre><code>tier_id     tier_name       points_required
  1           Silver          100
  2           Gold            200
  3           Platinum            300
  </code></pre>
  
  <p><strong>tbl_tier_earned</strong></p>
  
  <pre><code>id      tier_id     uid
  1       1           1
  2       2           1
  3       3           1
  4       1           2
  5       2           2
  6       1           3
  </code></pre>
  
  <p>I need unique users with their current tiers like:</p>
  
  <pre><code>first_name          last_name       email_id                    current_tier
  steve               martin          steve1@gmail.com            Platinum
  mark                lee             mark1@gmail.com             Gold
  </code></pre>
  
  <p>I have tried below query but it gives me only 1 result:</p>
  
  <pre><code>SELECT u.first_name,u.last_name,u.email_id, t.tier_name 
  FROM tbl_tier_earned AS tte 
  INNER JOIN tbl_user AS u 
  ON u.uid = tte.uid 
  INNER JOIN tbl_tier AS t 
  ON tte.tier_id = t.tier_id 
  WHERE u.email_id!="" 
  ORDER BY t.points_required DESC LIMIT 0,1
  </code></pre>
  
  <p>How can I retrieve above data using mysql query?</p>