title: SQL Select statement with Inner Join help
body: <p>Here is my SQL Statement which is not returning DISTINCT Thread Titles.</p>
  
  <pre><code>SELECT DISTINCT TOP 5 tblThread.Title, tblPost.Date 
  FROM tblPost 
  INNER JOIN tblThread ON tblPost.ThreadID = tblThread.ThreadID 
  ORDER BY tblPost.Date DESC
  </code></pre>
  
  <p>The common field between tblThread and tblPost is ThreadID.</p>
  
  <p>What I want this to do is return The latest 5 Distinct Thread Titles based on the latest 5 posts in tblPost.</p>
  
  <p>Example: If a thread called ASP.NET has been posted to two times and they are the two most recent posts, the Title of the thread (ASP.NET) should only appear once and at the top of the list.</p>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p>Stefan.</p>