Re: [sqlite] Re: Syntax for Multi-table Join

[Rich Shepard]

On Thu, 10 Jan 2008, Igor Tandetnik wrote:

I get a different error: no such column "f.subcomp". The reason for this
is that you use Fuzzyset fields in a subquery that's not coordinated with
Fuzzyset.

Igor,

  I could generate that error, too.

What you want is something like this:

select f.*, v.num_ts
from Fuzzyset as f join Variable as v
on (f.parent=v.name and f.comp=v.comp_name and f.subcomp=v.subcomp_name);

or equivalently

select f.*, v.num_ts
from Fuzzyset as f join Variable as v
where f.parent=v.name and f.comp=v.comp_name and f.subcomp=v.subcomp_name;

  Thank you very much. That resolves a long-standing uncertainty.

Rich

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------