Thread: Re: [HACKERS] Subselects and NOTs

Re: [HACKERS] Subselects and NOTs

From
Zeugswetter Andreas SARZ
Date:
This is what I did:
    create table a (a int, a1 char(8));
    create table b (b int);
    insert into a values (1, 'one');
    insert into a values (NULL, 'null');

and this is what I got from Informix:
> select * from a where a not in (select * from b);
          a a1
          1 one
            null
2 row(s) retrieved.
>  select * from a where not (a in (select * from b));
          a a1
          1 one
            null
2 row(s) retrieved.
> select * from a where not a in (select * from b);
          a a1
          1 one
            null
2 row(s) retrieved.
> select * from a where a<>(select * from b);
          a a1
No rows found.
> select * from a where a=(select * from b);
          a a1
No rows found.

Andreas