title: How to LEFT JOIN two tables with the same column name
body: <p>I want to LEFT JOIN two tables with the same column name.  I have two tables which I am trying to join but I keep getting an error:</p>
  
  <pre><code>column 'id' is ambiguous
  </code></pre>
  
  <p>returned in my JSON output.  </p>
  
  <p>My current query:</p>
  
  <pre><code>$sQuery = "
   SELECT SQL_CALC_FOUND_ROWS ".str_replace(" , ", " ", implode(", ", $aColumns))."
   FROM   $sTable
   LEFT JOIN
      $sTable2
      ON ($sTable2.id = $sTable.id)
  
   $sWhere
   $sOrder
   $sLimit
  ";
  </code></pre>
  
  <p>Produces that error.  How can I join these two tables as the join point when there is the same column name in each table?</p>