How do you do a negative join? - Mailing list pgsql-novice

From dj00302003@yahoo.com (Jay Davis)
Subject How do you do a negative join?
Date
Msg-id 1d17eeb7.0403201332.58f95e91@posting.google.com
Whole thread Raw
Responses Re: How do you do a negative join?
Re: How do you do a negative join?
List pgsql-novice
There must be a standard SQL method to query multiple
tables in the following way.  Lets say we have two
tables, 'allnames' and 'badnames'. We want to get the
following result:

"select name from allnames where name-is-not-in-badnames;"

Clearly I'm an SQL novice but I haven't found any examples
of such a query in my beginning SQL books.

Thanks.

pgsql-novice by date:

Previous
From: Mihai Tanasescu
Date:
Subject: Simple list tables question
Next
From: billybobc1210@yahoo.com (Bill C.)
Date:
Subject: Problems getting started: createdb fails