Compound Queries and Logical Operations
Queries may be joined together to create a compound query. When creating a compound query, the logical operators AND and OR are used to logically join the statements together
Remember there are only two logical answers to the questions that we can ask our database, true and false.
To satisfy a true condition (for the compound query)...
• an AND operation requires that all questions result in a true condition.
• an OR operation requires that only one question result in a true condition.