SQL Select where CustNo Not in Table B

Article View: borland.public.vdbase.data.sql

Article #961

Back to borland.public.vdbase.data.sql Previous Next

#961

From: Tom Gleaton
Date: Mon, 08 Jun 1998 00:00

9 lines
640 bytes

Table A & B each have a Customer No field.
How would I write an SQL statement to select all rows in table A,
that do not have a Customer Number in table B?

-- 
Thanks,
Tom Gleaton
County of Riverside,  Riverside California

Technical Details

Message-ID: <01bd92a1$9fba0440$384c96d1@dict2>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,6f0fb48f9c27fcb6,start
X-Google-Attributes: gidff5a1,public
From: "Tom Gleaton" <tgleaton@linkline.com>
Subject: SQL Select where CustNo Not in Table B
Date: 1998/06/08
Message-ID: <01bd92a1$9fba0440$384c96d1@dict2>
X-Deja-AN: 360576380
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql