UNION

select_statement
UNION [ ALL ]
select_statement

Example

SELECT * FROM (
    SELECT * FROM user WHERE id < 10
    UNION ALL
    SELECT * FROM user WHERE id > 15
);

SELECT * FROM (
    SELECT * FROM user WHERE id < 10
    UNION
    SELECT * FROM user WHERE id > 15
);

SELECT * FROM (
    SELECT * FROM user WHERE id % 3 = 0
    UNION ALL
    SELECT * FROM user WHERE id % 3 = 1
    UNION ALL
    SELECT * FROM user WHERE id % 3 = 2
);