title: SQL Query: Reference Another Table data for two variables in the same query
body: <p>I'm trying to run a MYSQL query where I need the same 'piece' of information from the source table twice in the destination...
  Let me explain:</p>
  
  <p>2 Tables: "<strong>Events</strong>" and "<strong>Archived Events</strong>".
  The "Archived Events" is a 'link' - bridging current open events to past (closed) events.
  This table only contains id's to the Event_ID in the Events table.</p>
  
  <p>What I want to do is get the Event Title for each combination in the archive table.</p>
  
  <p>EG:</p>
  
  <pre><code>   -----------------------------------
     |       ARCHIVE TABLE             |
     |PK|ClosedEventID |CurrentEventID |
     |1 |      5       |       3       |
     |2 |      2       |       3       |
     -----------------------------------
  
     -----------------------------------------
     |      EVENTS TABLE                     |
     |Event_ID | Event_Title | ............. |
     |    1    | Party 1     | ............. |
     |    2    | Party 2     | ............. |
     |    3    | Wedding 1   | ............. |
     |    4    | Funeral 1   | ............. |
     |    5    | Pancake     | ............. |
     ----------------------------------------
  </code></pre>
  
  <p>I'm guessing it's going to be a join or a union or something; my SQL is fair, but my head is spinning trying to work this out.</p>
  
  <p>So what I would like done is that for each 'pair' in the archive events table would look like this once the query was run (so that I can deal with it in PHP...):</p>
  
  <pre><code>   -----------------------------------
     |       ARCHIVE TABLE             |
     |PK|ClosedEventID |CurrentEventID |
     |1 | Pancake      |   Wedding 1   |
     |2 | Party 2      |   Wedding 1   |
     -----------------------------------
  </code></pre>
  
  <p>Thank you for your help in advance! :)</p>