Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Interactive SQL Online Help Interactive SQL Version 16.0 » Query Editor Help

Expression Editor

The Expression Editor helps you create search conditions, computed columns, and subqueries. To edit existing expressions, highlight the expression before you open the Expression Editor. Otherwise, what you create in the Expression Editor is appended to previously existing expressions when you click OK.

Dialog components

Adding a subquery

To create a subquery, open the Expression Editor and click the Subquery button (located next to the NOT button). This opens the Subquery dialog, which looks identical to the main Query Editor except that the words Subquery are in the title bar. You create a subquery just as you create a main query.

Editing a subquery

To edit a subquery in the Query Editor, highlight the subquery in the Criteria box, and click the Expression Editor button. Highlight the code in the Expression Editor, and click the Subquery button.

Additional information

For more information, see Introducing the Query Editor.