Aggregate Queries

An Aggregate Query is used to combine data from multiple queries or tables into a single result set.

Aggregate Queries are commonly used for:

1. Joining data from different sources
2. Combining related datasets
3. Creating consolidated reports

note

Whenever possible, perform joins within Standard Queries, as Aggregate Queries may impact performance when processing large datasets.