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.