Union

NoQL supports UNION and UNION ALL.

Example UNION usage

SELECT * FROM top_rated_films
UNION
SELECT * FROM most_popular_films;

Example UNION ALL usage

SELECT * FROM top_rated_films
UNION ALL
SELECT * FROM most_popular_films;

Unions can be used in sub queries.