title: how do I update fields with a select for the where clause?
body: <p>I have tables, 1 called "articles" and another called "links".</p>
  
  <p>I want to take the url and title from the table links and update the articles table with the data from the links table. I am unsure how to do this. The links table has article_id referenced to it, can anyone help? </p>
  
  <p>Here is some pseudo-code if this helps?</p>
  
  <pre><code>UPDATE articles 
     SET articles.url, 
         articles.title = (SELECT links.url, 
                                  links.title 
                             FROM links 
                            WHERE articles.id = links.article_id)
  </code></pre>
  
  <p>Does this make sense?</p>