# E071-03: EXCEPT DISTINCT table operator

statement ok
CREATE TABLE TABLE_E071_03_01_011 ( ID INT PRIMARY KEY, A INT );

statement ok
CREATE TABLE TABLE_E071_03_01_012 ( ID INT PRIMARY KEY, B INT );

statement ok
INSERT INTO TABLE_E071_03_01_011(ID,A) VALUES (0,1),(1,2),(2,1)

statement ok
INSERT INTO TABLE_E071_03_01_012(ID,B) VALUES (1,2)

query I
SELECT A FROM TABLE_E071_03_01_011 EXCEPT DISTINCT SELECT B FROM TABLE_E071_03_01_012
----
1

query I
SELECT A FROM TABLE_E071_03_01_011 EXCEPT ALL SELECT B FROM TABLE_E071_03_01_012
----
1
1
