Creating an alias

From: Bruce Parker (bparkerhsd_at_nospam.nospam)
Date: 02/15/05


Date: Tue, 15 Feb 2005 07:25:06 -0800

I have an alias that can get very long because it maintains a information of
where it came from. Is there a way to alias an alias?

My first thought was:

Declare @T1 varchar(128)
Set T1 = 'MyAlias'
...
Inner Join Table1 as @T1

This of course does not work. Is there way?