> -----Original Message----- > From: Rich Shepard [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 10, 2008 4:10 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] Syntax for Multi-table Join > > 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.
select foo as bah from baz, not select foo from baz as bar, I think. -- James ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
