Re: [sqlite] Syntax for Multi-table Join

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 sq

RE: [sqlite] Syntax for Multi-table Join

A tired James wrote: > > select foo as bah from baz, not select foo from baz as bar, I think. > > -- James Evidently I don't think too well this afternoon; please disregard this... -- James - To unsubscribe, send email

RE: [sqlite] Syntax for Multi-table Join

> -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 pag

[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 fro