Re: [sqlite] Finding Missing Table Rows -- FOUND

2008-05-16 Thread twright
*** Automatic Responder *** Thanks for your email! I will be out (on vacation) until Thursday May 18th. Please contact me after Thursday. Sincerely, Thom Wright ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Finding Missing Table Rows -- FOUND

2008-05-16 Thread twright
*** Automatic Responder *** Thanks for your email! I will be out (on vacation) until Thursday May 18th. Please contact me after Thursday. Sincerely, Thom Wright ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Finding Missing Table Rows -- FOUND

2008-05-16 Thread Rich Shepard
On Thu, 15 May 2008, Darren Duncan wrote: > Try this: > > (select f.parent as c1, f.subcomp as c2, f.comp as c3 > from Fuzzyset as f) > minus > (select r.var_name as c1, r.subcomp_name as c2, r.comp_name as c3 > from Rules as r) > > The result should have 3 columns and 2 rows. Darren, I see