title: Update SQLite table based on data in another table
body: <p>I have two tables in SQLite which look like this</p>
  
  <pre><code>TABLE_X    
  ____________________
  | id | C1 | C2 | C3 | C4 |
  | 10 | 99 | 03 | 04 | 00 |
  | 60 | 88 | 20 | 30 | 40 |
  
  
  TABLE_Y
  ___________     
  | id | C2 |
  | 10 | 11 |
  | 60 | 22 |
  </code></pre>
  
  <p>I am trying to write query to update records on Table X based on records in Table Y
  The condition for the updateis something like the following</p>
  
  <pre><code>update table_x
     set table_x.c1 = 100,
         table_x.c2 = table_y.c2
   where table_x.id = table_y.id
  </code></pre>
  
  <p>But when I try to do this I get an error message saying</p>
  
  <blockquote>
    <p><strong>NO such column: table_y.c2</strong></p>
  </blockquote>