Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with SQL statement
Hello,
sorry, the wrong database(sqlserver),
in oracle it is (+)
Norbert
Niall Litchfield wrote:
>
> "Norbert Weintz" <norbert_at_weintz.de> wrote in message
> news:39EAFB8E.2719CABA_at_weintz.de...
> > select A.barcode from TableA A, TableB B
> > where B.barcode =* A.barcode
> > and B.barcode is null
> >
> > not tested
>
> I'm not familiar with =* i'd have gone for the (+) operator.
>
> Niall
Received on Thu Oct 19 2000 - 08:38:50 CDT