title: How to handle ambiguous column names when I have so many columns?
body: <p>Here is my problem.
  Suppose I have 3 tables namely A, B and C, each of them has a lot of columns which I do not want to list all in my query.</p>
  
  <p>And here I want to do the query below:</p>
  
  <pre><code>select * from A, B, C where A.b_id = B.b_id, and B.c_id = C.c_id;
  </code></pre>
  
  <p>Only then I find that B and C both have a column named "kidding", so I cannot run  this query due to the ambiguous column names issue.</p>
  
  <p>I know that list all the column I want instead of * can handle this problem but I really do not want to do it because of the number of columns I need. So is there some smart way to handle this problem? I just need to bring all columns from A, B and C while I can set two alias for B.kidding and C.kidding.</p>
  
  <p>Thanks,</p>