RE: Arrrrrrrrrrrrr
Actually, I think the NOT NULL should go in the subquery
> -----Original Message-----
> From: Reinhard Habichtsberg [SMTP:Reinhard.Habichtsberg@unilux.de]
> Sent: Friday, December 03, 1999 9:50 AM
> To: informix-list@iiug.org
> Subject: Re: Arrrrrrrrrrrrr
>
> Hi Steve,
>
> it seems ok. Maybe a little trick helps:
>
> select payroll_num from person_load
> where payroll_num is not null
> and> payroll_num not in
> (select payroll_num from personnel)
>
> I cannot explain it, but sometimes there are problems
> with NULL values
>
> HTH
> Reinhard
>
> Steve Peake <puppet@dial.pipex.com> schrieb in im Newsbeitrag:
> 828nd7$2h9pu$1@fu-berlin.de...
> > I've been working on this for hours, can anyone explain why this
> doesn't
> > work:
> >
> > select payroll_num from person_load
> > where payroll_num not in
> > (select payroll_num from personnel)> >
> > I have a unique payroll_num in the person_load table that doesn't
> appear in
> > the personnel table, but the query never returns any data. I am
> used to
> > using oracle, and this would work first time using this. Is there
> any
> > difference between the statements in oracle and informix that is
> confusing
> > me here?
> >
> > cheers
> >
> > Steve
> >
> >
>