Re: [sqlite] OT: SQL Help

2006-06-07 Thread 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 trea

RE: [sqlite] OT: SQL Help

2006-06-07 Thread Jarrett, Zachary
chary Sent: Wednesday, June 07, 2006 12:44 PM To: '[email protected]' Cc: '[EMAIL PROTECTED]' Subject: RE: [sqlite] OT: SQL Help If filestamp is your identifier, the following statement will do the job... DELETE FROM files WHERE filestamp IN (SELECT filestamp FROM snapshot

RE: [sqlite] OT: SQL Help

2006-06-07 Thread Jarrett, Zachary
ite.org Subject: [sqlite] OT: SQL Help 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 sna

[sqlite] OT: SQL Help

2006-06-07 Thread Craig Morrison
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) UNIQ