Grouping selection criteria in the SQL designer

Topic group Related topics

In the SQL designer, individual selection criteria can be grouped together to form nested selection criteria.

To group selection criteria,

1. Select the rows to group by holding down the Ctrl key and clicking each row you want to select in the drill-down column. The drill-down column is located in the leftmost column of the grid and doesn’t have a header description.

2. Right-click in the drill-down column and choose Drill-Down from the context menu.

Drill-down column

The drill-down column is the leftmost column of the grid and doesn’t have a header description. If the query contains a nested selection criteria, a drill-down arrow appears next to the nested row. Clicking this arrow "drills down" into the expression. If a grouped expression has already been drilled down, a drill-out arrow appears in upper left cell of the grid. Clicking this arrow "drills out" the expression.

Ctrl+U and Ctrl+D also allow you to drill up and drill down respectively.

To ungroup selection criteria,

Change the operator in the grouped expression to its opposite. For example, if you have the previous grouped expression:

(City = ‘Freeport’) OR (Company = ‘Unisco’)

Change the OR to an AND:

(City = ‘Freeport’) AND (Company = ‘Unisco’)