On 2011-05-14, Seb <spluque@gmail.com> wrote:
> Hi,
>
> This probably reflects my confusion with how self joins work.
>
> Suppose we have this table:
> If I want to get a table with records where none of the values in column
> b are found in column a, I thought this should do it:
use the "NOT IN" operator with a subquery to retch the disallowed
values.
select * from tmp where a NOT IN (select b from tmp);
--
⚂⚃ 100% natural