OR « Query « SQL Server / T-SQL Tutorial

1.20.1.A search condition that uses the OR operator
1.20.2.use the AND and OR logical operators to create compound conditions that consist of two or more conditions.
1.20.3.use the OR operator to specify that the search must satisfy at least one of the conditions.
1.20.4.The IN operator can be used together with the Boolean operator NOT.