A script-enabled browser is required for this page to function properly.

Creating a negating condition (Query Builder)

NOT can be used by itself or in combination with AND or OR. NOT AND returns all rows except where all the conditions are met; NOT OR returns all rows except where any of the conditions are met.

To create a negating condition:

  1. In the Query window, build a condition.
  2. Place your cursor in the condition field in the Conditions panel, and type or select a logical operator in the Icon Bar for the condition.
  3. Click the NOT button in the Icon Bar.

See also

About conditions (Query Builder)

 

Adding conditions to a query (Query Builder)

 

Condition syntax (Query Builder)

 

Controlling join conditions in linked queries (Query Builder)

 

Creating a nested condition (Query Builder)

 

Pasting a function (Query Builder)