Logical Operators
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
| Expression | Result |
|---|---|
| (field_expression_1AND field_expression_2) | Evaluates as true if both field_expressions are true. |
| (field_expression_1OR field_expression_2) | Evaluates as true if either field_expression is true. |
| (field_expression_1AND NOT field_expression_2) | Evaluates are true if field_expression_1 is true and field_expression_2 is false. |