Query editor
witha as (SELECT*FROM (values (1,'c'),(2,'d'),(3,'e')) as v(a, letter_two)),b as (SELECT*FROM (values (2,5),(3,5),(4,5)) as v(a, letter))SELECT a FROM aINTERSECT --change this to UNION ALL or EXCEPTSELECT a FROM b
Query editor
1with2a as (3SELECT4*5FROM (values (1,'c'),(2,'d'),(3,'e')) as v(a, letter_two)6),78b as (9SELECT10*11FROM (values (2,5),(3,5),(4,5)) as v(a, letter)12)1314SELECT a FROM a15INTERSECT --change this to UNION ALL or EXCEPT16SELECT a FROM b17