[thelist] SQL: Negative Join?

Frank lists at frankmarion.com
Mon Sep 29 00:56:02 CDT 2003


I've got two tables each with client names and phone numbers. One table is 
a new list, the other is a list of clients to delete. Is there a way of 
doing a "negative join"? Something like

SELECT k.columns
FROM keepers k
LEFT JOIN tossers t
    ON k.client <> t.client;

?




--
Frank Marion     lists at frankmarion.com      Keep the signal high.  



More information about the thelist mailing list