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.