Use this page to create an original subquery or to create a subquery
that is based on an existing query.
- Create a subquery that is based on an existing query
- Select this option if you want to use a query
that you have already created as the basis for your new subquery.
- Create an original subquery
- Select this option if you want to type all the
text for the new subquery.
- unlabeled list
- If you selected the Create a subquery
that is based on an existing query option, select a query from
this list. The text for the query that you select is added to the Create
or edit a SELECT statement field for you to edit.
- Create or edit a SELECT statement
- Change the text of query that you selected. The
changes that you make to the text in this field affect only the new subquery.
The text of the selected query remains unchanged.
- Type a SELECT statement
- Type the text for the new SELECT statement. If
you prefer not to type all the text for the statement, you can cancel the
Expression Builder wizard, use the SQL builder to create the SELECT statement,
and then reopen the wizard and select the query that you created.