Aristotle Support

"And" Sub-Query Joins

Article ID: 752
Last updated: 07 Mar, 2010

"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.

This article was:   Helpful | Not helpful Report an issue


Article ID: 752
Last updated: 07 Mar, 2010
Revision: 1
Views: 371
Prev     Next
Sub-Queries       "Or" Sub-Query Joins