"And" Sub-Query Joins

"And" Sub-Query Joins

When doing a sub-query with an "and" sub-query join, only records with an entry in the specified table that meet all conditions of the sub-query will be returned. For example, if you specify under table MonetaryContributions that  checkdate is less than 1/1/2000 and modify it with an "and" sub-query join specifying that amount exactly matches 100, you will locate individuals and organizations with a monetary contribution of $100 made before January 1, 2000.

An individual with a monetary contribution made after January 1, 2000 and an in-kind contribution of $100 made before January 1 would NOT appear in the results. While each meets one of the conditions, neither of them meets both conditions.