title: Need help with complex join
body: <p>I cannot figure out this complex join..</p>
  
  <p>I have 3 tables:</p>
  
  <p>I want to join threads id with posts thread_id and users id with posts poster and threads poster..</p>
  
  <p><b>Threads:</b></p>
  
  <ul>
  <li>ID int(10)</li>
  <li>Subject varchar(100)</li>
  <li>Message text</li>
  <li>Poster int(10)</li>
  </ul>
  
  <p><b>Posts:</b></p>
  
  <ul>
  <li>ID int(10)</li>
  <li>Poster int(10)</li>
  <li>Message text()</li>
  <li>Thread_id int(10)</li>
  </ul>
  
  <p><b>Users:</b></p>
  
  <ul>
  <li>ID int(10)</li>
  <li>username varchar(50)</li>
  </ul>
  
  <p>Help is much help is much appreciated</p>