Hi Rich,
On Thu, 10 Jan 2008 16:10:14 -0800 (PST), Rich Shepard
<[EMAIL PROTECTED]> wrote:
> I cannot find the specific syntax on the web site's SELECT page nor in
>Owens' book. It should not be as difficult to craft the statement as I'm
>finding it to be.
>
> Here's what I want (with the sqlite3 error following):
>
> SELECT * from Fuzzyset as f
> INNER JOIN (SELECT num_ts from Variable as v
> WHERE f.parent=v.name AND f.comp=v.comp_name and
> f.subcomp=v.subcomp_name)
>
>SQL error: near "as": syntax error
>
> A clue stick is appreciated.
>
>Rich
I'm nit sure what result you want to have, but perhaps this
selects what you need:
SELECT *,v.num_ts
FROM Fuzzyset as f
INNER JOIN Variable as v
ON (f.parent=v.name
AND f.comp=v.comp_name
AND f.subcomp=v.subcomp_name);
HTH
--
( Kees Nuyt
)
c[_]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
