title: How to display table name as prefix to column name in SQL result
body: <p>Two tables. Some overlapping fieldnames. Join query. Same column name comes up twice. I would like to add the table name as a prefix to the column name just to make it easier to read. I am using the wild card * and I would like to continue to use the wildcard in the solution. </p>
  
  <p>The query could be something like this:</p>
  
  <pre><code>SELECT *
  FROM Loan l JOIN
       LoanInstallment li
       ON l.LoanId = li.LoanId
  </code></pre>
  
  <p>And the filed names of the result could be something like this:</p>
  
  <pre><code>LoanID | Amount | Date | LoanID | Amount | Date |
  … records
  </code></pre>
  
  <p>Where I would like it to be</p>
  
  <pre><code>l.LoanID | l.Amount | l.Date | li.LoanID | li.Amount | li.Date |
  … records
  </code></pre>
  
  <p>This should be very easy to do because it is obvious that SQL has no problem with having field names the same, so there is an invisible table name along with every column. </p>
  
  <p>How do I display the table name, as a prefix, to the column name?</p>
  
  <p>Happy Solstice</p>