title: SQL Join three tables
body: <p>I'm learning advanced SQL queries little by little and I'm fairly stumped with a problem:</p>
  
  <p>I have three tables: <code>news</code>, <code>author</code>, and <code>images</code>. Each field in the <code>news</code> table (<code>newsID</code>) is a news story, which then has an associated author in the <code>author</code> table (<code>authorID</code>) and can have any number of images associated in the <code>images</code> table. Each image has and associated (<code>newsID</code>). So each story has one author but can have several images.</p>
  
  <p>I want to make a list of all news stories and use <em>just one</em> of the images as a thumbnail image. The problem is that any sql query I try to list the <code>news</code> items with gives me results equal to the number of images in the <code>images</code> table rather than the number of <code>news</code> items.</p>
  
  <p>I don't know where to go from here. Any help would be greatly appreciated.</p>