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

2008-01-10 Thread 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.*

[sqlite] Re: Syntax for Multi-table Join

2008-01-10 Thread Igor Tandetnik
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