Logical Join Predicates

Purpose

Join predicates (also known as Boolean operators) join Boolean values.

Syntax

Logical Join Predicates

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
SELECT true AND false AS res1,
       NOT false      AS res2,
       true OR null   AS res3;