
• Additional SQL transformations that support subqueries include Delete, Update, and
Merge. Note that the subquery version of the Query Builder window includes a
Name (ALIAS) field. This field enables you to specify an alias for the subquery
when it is used in a query.
The Query Builder window contains the following tabs:
Tabs Description
Source Identifies the tables used in a query. When
multiple tables are selected, you can specify
the join type and any applicable join
conditions. Finally, you can create a subquery
that you can use as the source of a query.
Note: In the Subquery window, tables from
all database management systems are handled ...