Re: [sqlite] OT: SQL Help

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

chary Sent: Wednesday, June 07, 2006 12:44 PM To: 'sqlite-users@sqlite.org' 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

If filestamp is your identifier, the following statement will do the job... DELETE FROM files WHERE filestamp IN (SELECT filestamp FROM snapshot); I recommend that you check out some tutorials online and at least learn the basics. There's no reason to continue to suck at SQL. A good place to s