Skip to main content

The UNION keyword is used to combine the result-set of two or more SELECT statements. For example:

SELECT tickets.id
FROM (
     (SELECT tickets.id FROM tickets WHERE tickets.id > 0 AND tickets.id < 5)
     UNION DISTINCT
     (SELECT tickets.id FROM tickets WHERE tickets.id > 5 AND tickets.id < 10)
) AS 'tickets'

UNION needs to be embedded inside FROM (technically making it a sub-query).

Authors list

First published: 23/03/2018

Last updated: Sep 17, 2020 by Grace Howlett