Equivalent to in SQL. The number of rows is always the sum of the number of rows from the two input tables. To replicate UNION DISTINCT, see set operations.

PRQL

SQL

SELECT
  *
FROM
UNION
ALL
SELECT
  *
FROM
  employees_2

Removes rows that appear in another relation, like . Duplicate rows are removed one-for-one.

SELECT
  *
FROM
  employees_1 AS t
EXCEPT
  ALL
  *
FROM
  employees_2 AS b

PRQL

SQL

SELECT
FROM
  employees_1 AS t
INTERSECT
ALL
SELECT
  *
FROM

Don’t mind the and _param., these are compiler implementation detail for now.