[thelist] SQL: Negative Join?

Frank frank at frankmarion.com
Sun Sep 28 15:16:27 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 <frank at frankmarion.com>  



More information about the thelist mailing list