title: Distinct doesn't work when joining two tables
body: <p>I have two tables: Employee and DealerSessions which are linked based on the EmployeeID. The following search query does not return the distinct EmployeeID's. Any ideas?</p>
  
  <pre><code>SELECT  distinct e.EmployeeID, e.Name, e.Surname, ds.DealerSessionsID, ds.SessionID, ds.EmployeeID AS Expr1
  FROM Employee AS e INNER JOIN
                        DealerSessions AS ds ON e.EmployeeID = ds.EmployeeID
  WHERE (ds.SessionID = 154)
  </code></pre>