Navigation:  Queries >

Query - Compound Queries and Logical Operations

Print this Topic Previous pageReturn to chapter overviewNext page

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 (Product or Vendor Records), 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.

 


Page url: http://www.encouragersoftware.com/help/index.html?compound_queries_and_logical_o.htm