title: Update Query with INNER JOIN between tables in 2 different databases on 1 server
body: <p>Need some SQL syntax help :-)</p>
  
  <p>Both databases are on the same server</p>
  
  <pre><code>db1 = DHE
  db2 = DHE_Import
  
  UPDATE DHE.dbo.tblAccounts 
  INNER JOIN DHE_Import.dbo.tblSalesRepsAccountsLink 
      ON DHE.dbo.tblAccounts.AccountCode = DHE_Import.tblSalesRepsAccountsLink.AccountCode 
  SET DHE.dbo.tblAccounts.ControllingSalesRep = DHE_Import.dbo.tblSalesRepsAccountsLink.SalesRepCode
  </code></pre>
  
  <p>I can do a query in Access with linked tables with similar syntax - BUT SQL doesn't like it.</p>
  
  <p>I'm sure it's a simple issue :-D</p>
  
  <p>Thanks!</p>