Re: Arrrrrrrrrrrrr[solution]
Steve Peake <puppet@dial.pipex.com> wrote in message
news:82b65e$2jlmc$1@fu-berlin.de...
> Reinhard Habichtsberg <Reinhard.Habichtsberg@unilux.de> wrote in message
> news:828osj$dit$1@news06.btx.dtag.de...
> > 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
>
> Thanks to all who replied, someone also suggested this problem with nulls
> via email and the personnel table does contain some records with nulls in
> this field, so I will gice this a spin on monday.
>
> regards
and for anyone searching usenet that did the trick.
Steve