title: SQL Server CE Update table from another table
body: <p>Having trouble trying to adjust what is usually a simple update from one table to another:</p>
  
  <pre><code>UPDATE t2 
  SET Country_FK = t1.Country_ID 
  FROM dbo.CountryCity t2
  INNER JOIN dbo.Country t1 ON t2.country = t1.ISO
  </code></pre>
  
  <p>Doing a bit of research, SQL Server CE does not like the <code>FROM</code> clause in a join.</p>
  
  <p>I just can't seem to get the syntax right to work on SQL Server CE.</p>
  
  <p>Any suggestion are more than welcome.</p>
  
  <p>Thanks!!</p>