After you have created a record set with a tag or function, you can query the record set in several dependent queries. A query that retrieves data from a record set is called a Query of Queries. A typical use of a Query of Queries is to retrieve an entire table into memory with one query, and then access the table data (the record set) with subsequent sorting or filtering queries. In essence, you query the record set as if it were a database table.
Note: Because you can generate a record set in ways other than using the cfquery
tag, the term In Memory Query is sometimes used instead of Query of Queries.