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 the
*** 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
*** 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
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 2
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 EXISTS
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
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
Yes,
