You can use an column alias in the select list of nested select statements.
column_heading = expression
expression column_heading
expression as column_heading
1> select * 2> from syscolumns c 3> where c.id in ( 4> select o.id as tableid 5> from sysobjects o 6> where o.name like '%attr%')SAP ASE ignores the alias (the allowed column heading) in this example.