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.
Article ID: 752
Last updated: 07 Mar, 2010