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_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. |
Add Comment