Not sure how to use intersect

[richb-hanover]

I have the following SQL query to find rows where certain columns match in two tables:

select NU_Map, NU_Lot, NU_Unit from SalesNotUsed
INTERSECT
select SC_Map, SC_Lot, SC_Unit from SalesConsidered61

I have seen documentation for intersect, but horsing around in the Playground doesn't allow me to build a query... [faulty query deleted. See next post]

[richb-hanover]

I finally figured out that I could define separate tables, then INTERSECT them. That led me to create the following query.

The resulting SQL (below) is almost correct. I had to remove ALL from the query to get it to execute (SQLite database manager)

let nu = (
  from SalesNotUsed
  select [
    NU_Map,
    NU_Lot,
    NU_Unit,
  ]
)

let sc = (
  from SalesConsidered61
  select [
    SC_Map,
    SC_Lot,
    SC_Unit,
  ]
)
from nu
intersect sc

gives this SQL:

WITH nu AS (
  SELECT
    "NU_Map",
    "NU_Lot",
    "NU_Unit"
  FROM
    "SalesNotUsed"
),
sc AS (
  SELECT
    "SC_Map",
    "SC_Lot",
    "SC_Unit"
  FROM
    "SalesConsidered61"
)
SELECT
  "NU_Map",
  "NU_Lot",
  "NU_Unit"
FROM
  nu AS t
INTERSECT
ALL
SELECT
  *
FROM
  sc AS b

-- Generated by PRQL compiler version 0.4.2 (https://prql-lang.org)

[richb-hanover]

@max-sixty Is the ALL generated by PRQL an error? Or do I need some other option on the INTERSECT? Thanks