title: ambiguous column error when joining 2 tables which have the same column name
body: <p>in my table A {ID, FID, Name , Age}
  <br/>in my table B{ID, Job}</p>
  
  <p>When I use </p>
  
  <pre><code>SELECT ID // I want to get the ID of table B //**error**//
  FROM A TA JOIN B TB
  ON TA.ID = TB.FID
  ORDER BY TA.Name;
  </code></pre>
  
  <p><strong>Error</strong>: ambiguous column name ID</p>
  
  <p>Is there anyway to do that without having to rename the column name? (The Worst scenario)
  <br/>Thank you</p>