title: Include table name in column from select wildcard sql
body: <p>Is it possible to include table name in the returned column if I use wildcard to select all columns from tables?</p>
  
  <p>To explain it further.  Suppose I want to join two tables and both tables have the column name “name” and many other columns.  I want to use wildcard to select all columns and not explicitly specifying each column name in the select.</p>
  
  <pre><code>Select *
  From 
  TableA a,
  TableB b
  Where 
  a.id = b.id
  </code></pre>
  
  <p>Instead of seeing two column with same name "name", could I write a sql to return one column name as "a.name" (or TableA.name) and one as "b.name"(or TableB.name) without explicitly putting the column name in select?  </p>
  
  <p>I would prefer a solution for mssql but other database could be a reference too.</p>
  
  <p>Thanks!</p>