title: UPDATE on two INNER JOINed tables in SQL Server Compact 4
body: <p>I'm trying to update values between two tables in sql server compact edition 4.0. My sql is like below:</p>
  
  <pre><code>UPDATE ei SET ei.EstateID=e.EstateID FROM EstateImages ei
      INNER JOIN Estates e ON e.TempKey=ei.TempKey
  </code></pre>
  
  <p>Also tried this:</p>
  
  <pre><code>UPDATE EstateImages SET EstateID = 
      (SELECT EstateID FROM Estates WHERE TempKey = EstateImages.TempKey)
  </code></pre>
  
  <p>I'm having error:</p>
  
  <pre><code>There was an error parsing the query.
  [ Token line number = 1, Token line offset = 37, Token error = SELECT ]
  </code></pre>