*** 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
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
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
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
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
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
7 matches
Mail list logo