First page Back Continue Last page Overview Text


SQL supports using UNION, INTERSECT, and EXCEPT to combine the output from multiple queries.

UNION returns all rows in either query, INTERSECT returns all rows in both queries, and EXCEPT returns all rows in the first query that aren't in the second.

Sequel supports all of these clauses using methods with the same name. The first dataset is sent the compound method using the second dataset as an argument.