Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help with SQL statement

Re: Help with SQL statement

From: Norbert Weintz <norbert_at_weintz.de>
Date: Thu, 19 Oct 2000 15:38:50 +0200
Message-ID: <39EEF96A.EC782E56@weintz.de>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US