title: MySQL join with two columns looking at same table
body: <p>I have a table with the fields:</p>
  
  <pre><code>orderID
  collection
  delivery
  username
  </code></pre>
  
  <p>collection and delivery are IDs and correspond to a record in the addresses table:</p>
  
  <pre><code>addressID
  address1
  address2
  address3
  town
  country
  </code></pre>
  
  <p>How can I write a query that shows all orders for a particular username but with the full address details for both collection and delivery.</p>