Get Set for Set Theory: UNION, INTERSECT and EXCEPT in SQL
In a tad more than six minutes, you’ll see exactly how UNION, INTERSECT and EXCEPT work, starting in MariaDB 10.3, a few years back.
Ian explains what they are for, and the option to change default behaviour of DISTINCT with ALL (of which the ALL option was introduced in MariaDB 10.5).
