union

Appends a UNION operator to the current query, combining its result set with another SELECT statement.

The UNION operator combines the result sets of two or more SELECT statements and removes duplicate rows between them. The SELECT statements being combined must have the same number of columns in their result sets with similar data types.

Example:

Employees
     .select(
         Employees.firstName,
         Employees.lastName,
         StringLiteral("Employee") AS "Type",
      ).union {
         Customers.select(
             Customers.firstName,
             Customers.lastName,
             StringLiteral("Customer"),
         )
}.execute(con)

This would generate SQL similar to: SELECT * FROM Employees WHERE department = 'Sales' UNION SELECT * FROM Employees WHERE department = 'Marketing';

Parameters

Type Parameters

See also