title: Mysql - How to alias a whole table in a left join
body: <p>I have a situation where a property table holds an address id (from the g_addresses table) and an applicant table <em>also</em> holds an address id from the g_addresses.
  I'd like to left join these together but select all the fields in the table.</p>
  
  <p>I know of using 'as' to make an alias for fields, but is there any way to produce an alias for a whole table?</p>
  
  <pre><code>SELECT *
  FROM (`reference`)
  LEFT JOIN `applicants` ON `applicants`.`id` = `reference`.`applicant_id`
  LEFT JOIN `g_people` applicant_person ON `applicant_person`.`id` = `applicants`.`person_id`
  LEFT JOIN `g_addresses` applicant_address ON `applicant_address`.`id` = `applicants`.`address_id`
  LEFT JOIN `properties` ON `properties`.`id` = `reference`.`property_id`
  LEFT JOIN `g_addresses` property_address ON `property_address`.`id` = `properties`.`address_id`
  WHERE `reference`.`id` = 4 
  </code></pre>
  
  <p>This produces a result containing only one address row and not both, 
  The row that is returned is the row from the final join and not the one previously, indicating it is overwriting when it is returned.</p>