To expand on what Dave has rightly said...
An SQL statement can only have one
WHERE
clause, so you need to expand the
WHERE
expression using the
logical operators
that SQL supports:
AND
and
OR
.
They both have the same format:
WHERE <Expression1> <Logical operator> <Expression2>
AND
combines expressions so the result is
TRUE
only if both expressions are
TRUE
. If the first expression is
FALSE
, the second is not evaluated.
OR
combines expressions so the result is
TRUE
if either of the expressions is
TRUE
. If the first expression is
TRUE
the second is not evaluated.
You can chain there together along with brackets to get complex WHERE clauses:
WHERE a AND b AND (c OR d)
Will be
TRUE
only if
a
and
b
are
TRUE
, and at least one of
c
and
d
are
TRUE
See here:
SQL Operators[
^]