title: Update table based on another table
body: <p>I'm trying to update a column in a table based on another column in another table.</p>
  
  <pre><code>UPDATE eval e
     SET rank = (SELECT p.desc
                   FROM Position p
                  WHERE p.id = e.faculty 
                    AND p.date &gt;= '2011-05-20'
                )
  </code></pre>
  
  <p><code>p.id</code> and <code>e.faculty</code> correspond. I want to update rank with <code>p.desc</code> if the id's are the same. (<code>e.faculty</code> and <code>p.id</code>) </p>
  
  <p>Any help will be great! :)</p>