Purpose
Join predicates (also known as Boolean operators) join Boolean values.
Syntax
Usage Notes
The following tables defines the behavior of join operators:
| AND | TRUE | FALSE | NULL |
| TRUE | TRUE | FALSE | NULL |
| FALSE | FALSE | FALSE | FALSE |
| NULL | NULL | FALSE | NULL |
| OR | TRUE | FALSE | NULL |
| TRUE | TRUE | TRUE | TRUE |
| FALSE | TRUE | FALSE | NULL |
| NULL | TRUE | NULL | NULL |
| TRUE | FALSE | NULL | |
| NOT | FALSE | TRUE | NULL |
Example:
Copy
SELECT true AND false AS res1,
NOT false AS res2,
true OR null AS res3;