This window appears if you select the Subquery push button in the WHERE Clause dialog box or the HAVING Clause dialog box.

A subquery is a SELECT statement nested inside a clause of a parent SELECT statement.

You can nest a subquery up to five levels deep within a parent SELECT statement. The Subquery Level indicator shows the current nesting level.

Use the Subquery Editor window the same way you would use the SQL Editor window.

When you are finished building the subquery, select the Done push button to return to the WHERE Clause dialog box or the HAVING Clause dialog box.

The text of the subquery appears in the Expression field that last had the focus.