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

*** 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 http://sqlite.org:8080/cgi-bin/

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

*** 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 http://sqlite.org:8080/cgi-bin/

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

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 t

Re: [sqlite] Finding Missing Table Rows

Gerry Snyder wrote: > Darren Duncan wrote: >> Clue stick coming up. There's a much simpler solution. >> >> You should be using relational difference instead, the MINUS keyword, whose >> syntax is the same as UNION but for the keyword. >> > I think maybe you mean EXCEPT, not MINUS. > > Gerry

Re: [sqlite] Finding Missing Table Rows

Darren Duncan wrote: > Clue stick coming up. There's a much simpler solution. > > You should be using relational difference instead, the MINUS keyword, whose > syntax is the same as UNION but for the keyword. > I think maybe you mean EXCEPT, not MINUS. Gerry _

Re: [sqlite] Finding Missing Table Rows

Rich Shepard wrote: >I have two tables that should have the same number of rows, but one is 2 > rows short and I'm trying to identify which rows exists in the first table > (Fuzzyset) that's missing from the second table (Rules). > >I thought that a right outer join might work with "NOT EX

Re: [sqlite] Finding Missing Table Rows

= fs.comp); This "not exists (select 1 from ...)" has been pretty reliable for me. -Clark - Original Message From: Rich Shepard <[EMAIL PROTECTED]> To: Clark Christensen <[EMAIL PROTECTED]> Sent: Thursday, May 15, 2008 5:05:47 PM Subject: Re: [sqlite] Finding Miss

[sqlite] Finding Missing Table Rows

I'm embarrassed to have to ask for help on this query, but I am not finding the solution in my local references (Celko's "SQL for Smarties, 3rd ed", van der Lans' "Introduction to SQL, 4th ed") or by searching for Google. I have two tables that should have the same number of rows, but one is