Appendix D: SQL Server Reference
The SQL statement is the principal element in a report that defines which data the report gathers and returns as the result set or multiple result sets. This appendix provides detailed information about the common SQL query statements and the query design tools found in SQL Server that will help you to write effective SQL statements.
Provides detailed information and examples for using aggregate functions, joins, and the keyword phrase NOT IN.
Provides information about using the query design tools found in SQL Server 2000 and SQL Server 2005 to create or modify queries in SMS reports.