MySQL UNION

Stack the results of several SELECT queries into one result with UNION and UNION ALL.