Re: [sqlite] OT: SQL Help

[Craig Morrison]

Jarrett, Zachary wrote:

I misread what you wanted to do.  Now that I've re-read your post, I realize
that the proper statement for what you want to do uses NOT IN rather than

IN.

So...
DELETE FROM files
WHERE filestamp NOT IN
(SELECT filestamp FROM snapshot);

Zack

Thanks Zack, works a treat!

--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
  Controlling pseudoephedrine purchases.

http://www.mtsprofessional.com/
  A Win32 email server that works for You.