Both stack the results of two `SELECT`s vertically. `UNION` removes duplicate rows; `UNION ALL` keeps everything (faster because no dedup pass).