With all the other discussions going on with more important matters
please excuse this brief interruption..
I have two tables that are created thusly:
CREATE TABLE files (filehash VARCHAR(48) UNIQUE, filestamp INTEGER,
filename VARCHAR(2048));
CREATE TABLE snapshot (filehash VARCHAR(48) UNIQUE, filestamp INTEGER,
filename VARCHAR(2048));
I suck at SQL, so I plead for your advice..
I want to be able to delete all rows from 'files' that do *not* exist in
'snapshot'. My efforts to date have done nothing but leave me with less
hair.
Thanks.
--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
Controlling pseudoephedrine purchases.
http://www.mtsprofessional.com/
A Win32 email server that works for You.
