Refining SQL SELECT Statements

Use the Criteria Logic tab in the Query Specification area to refine criteria within an SQL SELECT, UPDATE, or DELETE statement. A block diagram appears in the Criteria Logic tab based on the columns you select and note for ordering. There are horizontal blocks on the left for the criteria, and vertical blocks on the right for the logical operators. You can change the value of an operator or the inclusion of a criterion by right-clicking a block, choosing Edit from the context menu, and changing the value in the Edit Criterion dialog box.

The logical tree that is created on this tab gives you a graphic equivalent of the WHERE clause of the SELECT statement.