Sorted:

Tag: UNION ALL

Merge SQL Result Sets: UNION ALL vs JOIN

MySQL UNPIVOT Guide

SQL Vertical Merge: Using UNION ALL

Merge SQL Tables: Temporary Table with UNION ALL