title: SQL Server/TSQL : Aliasing a column on table alias in join
body: <p>For efficiency, I'm trying to find out if there is a syntax which allows me to alias a column on a table using that table alias entirely in the from section and join sections. </p>
  
  <p>I know I could alias the column in the SELECT, but if I were using select * (I know, not good practice) it would not be available. I boiled down an example to show how I'd like to refer to the column name (<code>doubleAlias</code>):</p>
  
  <pre><code>SELECT * 
  FROM [table1] AS tl
     JOIN [table2] AS t2
     ON t1.[column1] = t2.[column1] AS doubleAlias
      WHERE doubleAlias = 'value';
  --INSTEAD OF
    --WHERE t2.[column1] = 'value'; 
  </code></pre>