title: mySql join - multiple records from same table
body: <p>Im looping through a list of forum posts, pulling the data from 2 tables, <code>posts</code> and <code>members</code>.</p>
  
  <p>I'm using a <code>LEFT JOIN</code> like</p>
  
  <p><code>SELECT m.name, p.title FROM posts LEFT JOIN members m ON p.poster=m.id</code></p>
  
  <p>That all works fine. But I also need to pull a different record from the members table, that of the <code>p.lastposter</code>. How would I do this? I can't add another JOIN in there can I because i'm already pulling a <code>m.name</code> and wouldn't it confuse it?</p>