Help with SQL statement

From: Peter Kirk <peter_kirk_at_alpha-gruppen.dk>
Date: Mon, 16 Oct 2000 14:38:23 +0200
Message-ID: <8sess8$sf$1@news.inet.tele.dk>

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. Received on Mon Oct 16 2000 - 07:38:23 CDT