Re: ANSI Semantics with NULL and NOT IN

In article <1992Sep16.024053.1744_at_binky.Binky.COM> irwin_at_binky.Binky.COM (Irwin Schafer) writes:
>Given table "r1":
>
> a1 a2 a3
> 1 A null
> 2 B 1
> 3 C 1
>
>On Ingres, this query returns the value "A"
> select a2 from r1 where a1 in
> (select distinct a3 from r1);
>
>However, this query returns no rows
> select a2 from r1 where a1 not in
> (select distinct a3 from r1);
>
>Where one may expect two rows ("B" and "C")

I tried it on Sybase and it does return "B" and "C"

>Irwin irwin_at_Binky.COM
Kobi Received on Wed Sep 16 1992 - 15:56:08 CEST