Re: Finding missing records

["John D. Burger" <john@xxxxxxxxx>]

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