August 22nd, 2008
AND, OR, and NOT, Part 2 of 3
Posted by
admin in
D. WHERE Clause
> NOT does not connect two conditions like AND and OR.
Instead it reverses a single condition.
> NOT is placed before the column name or expression
and not before the operator.
> NOT acts on only one condition.
To reverse two or more conditions,
repeat the NOT for each condition.
> The following two statements are equivalent.
Choose whichever style works best for you.
