title: Alias a column name on a left join
body: <p>Let's say I have two tables, and both their primary identifiers use the name 'id'. If I want to perform a join with these two tables, how would I alias the <code>id</code> of the table that I want to join with the former table?</p>
  
  <p>For example:</p>
  
  <pre><code>SELECT * FROM `sites_indexed` LEFT JOIN `individual_data` ON `sites_indexed`.`id` = `individual_data`.`site_id` WHERE `url` LIKE :url
  </code></pre>
  
  <p>Now, site_id is supposed to link up with <code>sites_indexed.id</code>. The actual <code>id</code> which represents the row for <code>individual_data</code> however has the same <em>title</em> as <code>sites_indexed</code>. </p>
  
  <p>Personally, I like to just use the name <code>id</code> for everything, as it keeps things consistent. When scripting server-side however, it can make things confusing.</p>
  
  <p>e.g.</p>
  
  <p><code>$var = $result['id'];</code></p>
  
  <p>Given the aforementioned query, wouldn't this confuse the interpreter?</p>
  
  <p>Anyway, how is this accomplished?</p>