RE: Why does IN work but NOT IN fails?
Try this and it will work...
Select u.ticker from universe u
> where u.ticker NOT in ( select ticker from holdings );
Regards,
Franky Thiel
-----Oorspronkelijk bericht-----
Van: Bashar Chalabi [mailto:bashar@ctl.com]
Verzonden: donderdag 30 december 1999 00:44
Aan: informix-list@iiug.org
Onderwerp: Re: Why does IN work but NOT IN fails?
> but this statement fails:
>
> Select u.ticker from universe
> where u.ticker NOT in ( select ticker from holdings );
What do you mean by 'fail'?
---
Bashar Chalabi
CTL, London