title: Ms Access query to SQL Server - DistinctRow
body: <p>What would the syntax be to convert this MS Access query to run in SQL Server as it doesn't have a DistinctRow keyword</p>
  
  <pre><code>UPDATE DISTINCTROW [MyTable] 
  INNER JOIN [AnotherTable] ON ([MyTable].J5BINB = [AnotherTable].GKBINB) 
                            AND ([MyTable].J5BHNB = [AnotherTable].GKBHNB) 
                            AND ([MyTable].J5BDCD = [AnotherTable].GKBDCD) 
  SET [AnotherTable].TessereCorso = [MyTable].[J5F7NR];
  </code></pre>