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: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Thu, 19 Oct 2000 13:49:38 +0100
Message-ID: <8smql1$1gl$1@soap.pipex.net> 






"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 - 07:49:38 CDT












Original text of this message













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