select * from t1 union select * from t2; select * from t1 union all select * from t2;