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 differences between your syntax and what I've tried. BTW, the
above throws a syntax error "near (", which is fixed by removing all the
parentheses.
Worked like a charm, thank you very much.
Now I need to figure out why the 'select count(*) from ...' returns two
fewer rows from the Rules table than from the Fuzzyset table when there
should be a rule for each fuzzyset. The first problem was a spelling error;
in one table the name was singular, in the other it was plural.
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
