Aristotle Support
Sub-Queries
Sub-Queries
Sub-Queries Sub-Queries are a powerful tool for doing complex targeting. A sub-query allows you to select more than one field at a time from the same table, thus simultaneously placing multiple conditions on a single set of search results.     Enter the first condition of your query by...
07 Mar, 2010
"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...
07 Mar, 2010
"Or" Sub-Query Joins
"Or" Sub-Query Joins When doing a sub-query with an "or" sub-query join, records with an entry in the specified table that meets at least one of the conditions will be returned. This is very similar to using a standard query "or" join. One difference is that since the sub-query is calculated as a...
07 Mar, 2010
Aggregates
Aggregates Aggregates are used to target based on multiple entries within a single table. For example, using the amount (non-aggregate) field in table AllContributions, you can select individuals who have given $100 or more at a single time.   Using the aggregate field Total Amount you can...
07 Mar, 2010