With this, you would be able to use fields from your select statement within your inner join subquery or udf

Remember the compatibility level of the database must be set to 90.

ex. exec sp_dbcmptlevel MyDb, 90