Combine search conditions in subqueries using AND, OR, and NOT.
Conditions are combined using AND as follows:
condition1 AND condition2
If both conditions are TRUE, the combined condition is TRUE. If either condition is FALSE, the combined condition is FALSE. If otherwise, the combined condition is UNKNOWN.
Conditions are combined using OR as follows:
condition1 OR condition2
If both conditions are TRUE, the combined condition is TRUE. If either condition is FALSE, the combined condition is FALSE. If otherwise, the combined condition is UNKNOWN. There is no guaranteed order as to which condition, condition1 or condition2, is evaluated first.