title: Update on join in Sqlite
body: <p>I have two two tables <code>A</code> and <code>B</code> in which both <code>P</code> columns are common and I need to use <code>update</code> command in <code>table B</code> only when both <code>p</code> values are same and <code>C column from table A</code> is given</p>
  
  <p>What I am trying is:</p>
  
  <pre><code>update B 
  set P =100 
  where B.P=A.P 
      and A.C=60
  </code></pre>
  
  <p>But it's giving me error no such column <code>A.P</code> </p>