title: Mysql multiple left joins on same table
body: <p>I have a table with two fields that reference the ID of another table. I need to pull the name from the other table for both fields.</p>
  
  <p>eg.<pre> 
  Table1
  worker1 = 2  (2 is key to other table)
  worker2 = 4</p>
  
  <p>Table2
  ID NAME
  1 Bill
  2 Fred
  3 John 
  4 Paul
  </pre></p>
  
  <p>I need to get $worker1name = Fred and $worker2name = Paul.</p>
  
  <p>So I will be saying something like:</p>
  
  <pre><code>SELECT xxx, NAME?, NAME? FROM Table1
  LEFT JOIN Table2 AS p1 ON Table1.worker1 = Table2.ID
  LEFT JOIN Table2 AS p2 ON Table1.worker2 = Table2.ID
  WHERE ...
  
  $table = mysql_query(...);
  $rec = mysql_fetch_assoc($table);
  $worker1name = $rec['???'];
  $worker2name = $rec['???'];
  </code></pre>
  
  <p>What do I insert in those last two statements to get the two names. Or more precisely what do I have to add to the SELECT to specify what I want the two different versions of the NAME field from table 2 to be called please?</p>