What is the difference between a crosstab query and a subquery?
A crosstab query is a query within a query, and a subquery summarizes large amounts of data.
A crosstab query summarizes large amounts of data, and a subquery is a query within a query.
A crosstab query transfers large amounts of data to another table, while a subquery is the term for the other table.
A crosstab query connects tables with unrelated data to one another, and a subquery manipulates the data to be error-free.