MySQL - How to append to select statements

UNION [ALL] is the magic command;

At least 2 select commands are needed for a union.

select a as name from t1;

union all

select b as name from t2;

this will have a query result from both table 1 and 2 as a single result set.