Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Part IV. Building Sophisticated Database Queries
Hour 15. Combining Multiple Queries into One
During this hour, you learn how to combine SQL queries into one by using the UNION, UNION ALL, INTERSECT, and EXCEPT operators. Once again, you must check your particular implementation for any variations in the use of the UNION, UNION ALL, INTERSECT, and EXCEPT operators.
The highlights of this hour include
An overview of the operators used to combine queries
When to use the commands to combine queries
Using the GROUP BY with the compound operators
Using the ORDER BY with the compound operators
How to retrieve accurate data
The query operators covered in this hour are not currently supported by MySQL, as of the version 3.23. As of version 4.0, the UNION operator will be supported.