title: select from 2 tables in a single query
body: <p>I have 2 tables, <code>article</code> and <code>image</code>.</p>
  
  <p>In order to extract all articles of a particular user, I need to:</p>
  
  <ul>
  <li><p>query all the articles </p>
  
  <p><code>SELECT * FROM article WHERE userid=100;</code></p></li>
  <li><p>then loop through these articles, and extract their images with:</p>
  
  <p><code>SELECT * FROM image WHERE articleid = currentArticleId;</code></p></li>
  </ul>
  
  <p>How can I achieve the same thing with just a single query?</p>