Using Multiple Condition Filters

Combine conditions in a WHERE clause with AND, OR and NOT, and use parentheses so they're checked the way you mean.

Updated

Cheat sheet: Using Multiple Condition Filters
Category
SQL
Level
Apprentice
Tags
Logical Predicate, sql, t-sql