title: PostgreSQL: Error: column of relation does not exist
body: <pre><code>UPDATE master as m
  SET m.husband = p.id
  From per as p
  where m.drid = p.drid AND p.address &gt; 80000 AND p.address &lt;= 154969
  </code></pre>
  
  <p>I have a table called <code>per</code> which has column called <code>id</code>. Basically, I want to copy these ids in my another table called <code>master</code> on the <code>where</code> clause. </p>
  
  <p>But I am getting an error saying, column "m" of relation "master" does not exist.
  m is not a column. I am not sure where I went wrong? </p>