Re: Help with SQL statement

From: Reinier <Reinier_Dickhout_at_hetnet.nl>
Date: Fri, 20 Oct 2000 08:33:33 +0200
Message-ID: <OIQMu$lOAHA.239@net003s>

Akram JARO <ajaro_at_synavant.com> wrote in message news:zOCG5.104$dT.6654_at_nreader1.kpnqwest.net...
> Select a.barcodes
> from tableA a
> where a.barcodes <>(select b.barcodes
> from tableB
> Where a.barcodes <> b.barcodes );
>
>

I don't think this will work, your subselect will retrieve (or may retrieve) multiple records, therefor you cannot use the '<>' operator, you'll have tu use 'not in' instead. But then still...

I would go for:

select barcodes
from table A
where barcodes not in (select barcodes from B);

Reinier. Received on Fri Oct 20 2000 - 01:33:33 CDT