Logical operators can be used in the WHERE clause in an ADQL query to make compound condition expressions. These operators are AND, OR, and NOT.

Condition Expression Syntax

(condition_expression LOGICAL_OPERATOR condition_expression)

Examples

ExpressionResult
(field_expression_1 AND field_expression_2)Evaluates as true if both field_expressions are true.
(field_expression_1 OR field_expression_2)Evaluates as true if either field_expression is true.
(field_expression_1 AND NOT field_expression_2)Evaluates are true if field_expression_1 is true and field_expression_2 is false.