title: How would distinct lead to more returned items
body: <pre><code>SELECT DISTINCT
      CONCAT(e.first_name, ' ', e.last_name) name,
      CONCAT(em.first_name, ' ', em.last_name) manager
  FROM
      Employees E
  JOIN Dept_Emp DE ON E.emp_no = DE.emp_no
  JOIN Dept_Manager DM ON DM.dept_no = DE.dept_no
  JOIN Employees EM ON EM.emp_no = DM.emp_no
  ORDER BY
      E.last_name,
      E.first_name
  </code></pre>
  
  <p>I get 886026 items returned.</p>
  
  <p>If I remove the DISTINCT key word I get 300024. How is that possible shouldn't if anything DISTINCT limit my returned items?</p>