Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help with SQL statement
Hi
Try:
select barcode
from table a
minus
select barcode
from table b;
In article <8sess8$sf$1_at_news.inet.tele.dk>,
"Peter Kirk" <peter_kirk_at_alpha-gruppen.dk>
wrote:
> Hi there
>
> I am *very* inexperienced with sql, and I am
trying to write a statement to
> select certain rows from one table, given that
no corresponding row exists
> in another table.
>
> That is, I have TableA, and TableB.
>
> TableA has these columns of interest:
> barcode;
> description;
>
> TableB has these columns of interest
> barcode;
> description;
>
> I want to find all "barcodes" that are in
TableA, but not in TableB. How can
> I do this is a single sql statement?
>
> I am experimenting with "outer join" at the
moment, but I'm not sure if this
> is entirely correct, and I can't seem to find
the correct syntax.
>
> Thanks for any help,
> Peter.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Oct 17 2000 - 17:36:53 CDT