Adaptive Server 15.7 expands the abilities of the asterisk (*).
In Adaptive Server 15.7 and later, you can use an asterisk in a nested
select statement that is not an
exists subquery as long as the asterisk:
- Is the only item in the select statement
- Resolves to a single table column for the nested query
In addition, you can:
- Restrict the selected columns in your nested query to only those belonging to a specific table by using the qualifier.* format, where qualifier is one of the tables in the from clause.
- Use the asterisk in a nested query that includes a group by clause.
When an asterisk resolves to a single table column for the nested query, the query is equivalent to explicitly using a single table column.
See "Queries: Selecting Data from a Table" in the Transact-SQL Users Guide.