title: How can I add a prefix to the column names of a join table in T-SQL?
body: <p>I am joining two tables in T-SQL which have the same column names and I want to distinguish them not only via a reference but also I want to distinguish them in the resulting joined table.</p>
  <p>I want to add a prefix for all the columns coming from the original or the joining table, e.g. Table1-Col1, Table2-Col1, etc.</p>
  <p>Is there a quick way to do that so that I won't have to repeat all the columns one by one in the query?</p>