title: using distinct doesn't work in sql server
body: <p>For some reason the following DISTINCT doesn't work. I was expecting only one b@gmail.com from Email column, but I get two identical ones.</p>
  
  <pre><code> 1&gt; SELECT DISTINCT t.Email,t.Lat_From,t.Lon_From 
        FROM tbl_Trip t,tbl_User u
        WHERE t.Email like u.Email AND u.Member_Of like 'yahoo'
   2&gt; go
  
    Email         Lat_From            Lon_From
    ------------- ------------------- -----------------------
    b@gmail.com   41.773289200000001  -71.378798500000002
    b@gmail.com   41.908398699999999  -71.436531000000002
  </code></pre>
  
  <p>(2 rows affected)</p>