title: MS-Access DISTINCTROW dosen't work anymore if linked tables a stored on SQL2008-Server
body: <p>I have a query in MS-Access like this:</p>
  
  <pre><code>select DISTINCTROW companies.* from companies, contacts, companies left join contacts on contacts.com_uid = companies.com_uid (This is the ms-access form of a standard "left-join")
  </code></pre>
  
  <p>[Companies] and [contacts] are linked views on a sql-server 2008, ODBC driver is "SQL server native client 10.0". Both views looks like "select * from [companies] where deleted = 0" and "select * from [contacts] where delete = 0"</p>
  
  <p>The result is wrong since companies are show as many contacts there are.</p>
  
  <p>If the Views are stored on a SQL2000 and linked with the ODBC-driver "SQL Server" everything is fine: All the companies are shown exactly once.</p>
  
  <p>Are there any solutions to get the result with DISTINCTROW again?</p>