2  Selecting Tables

This chapter includes a lot of things you can accomplish between the confines of SELECT and FROM statements.

2.1 UNION

UNION and UNION ALL are different - UNION does an implicit DISTINCT after appending the tables, UNION ALL does not.