You can use the Expression Builder wizard to create complex expressions
or subqueries. An expression specifies a value. It can be a simple value,
consisting of only a constant or a column name, or it can be more complex.
You can start the Expression Builder wizard from anywhere in the
SQL builder where you can use an expression in a statement (for example, the Column column
in the Design pane of a SELECT statement).
Prerequisite: The
SQL statement must be open in the SQL builder.
- In the Design pane of the SQL builder, double-click the cell in
which you want to create the expression.
- Click Build Expression in the list. The Expression Builder wizard opens.
- Select the type of expression that you want to build, and then
click Next.
- Specify information for the fields in the wizard, and then click Finish.