I wrote:
> Note that IN and EXCEPT are essentially set operators - if you have
> duplicates in either table, you might not get what you expect.
>
> If what you want is the =bag= difference of the two tables, you'll
> have to do something more complicated.
and then I immediately saw Pandurangan's message indicating that ALL
can be used to turn the set operators into bag operators, e.g., EXCEPT
ALL. Cool! (And not complicated at all.)
- John D. Burger
MITRE