What I'm trying to do is get the query strings that are stored in category executed against the text stored in data. Category is essentially a fixed set of content, whilst data changes. I could just step through category and execute each query individually, but I was looking for a way to do it in a single operation.
Basically ' which contain _any_ of the 'query' items from 'category'? ' -----Original Message----- On Behalf Of Scott Hess Should the 'data' table be joinable with the 'category' table in some way? Are you trying to match rows in 'data' which contain _all_ of the 'query' items from 'category', or which contain _any_ of the 'query' items from 'category'? Do you mean to have a WHERE clause or anything on what you're pulling in from 'category'? As presented, you've got "I do this, it doesn't work", which I can agree with. But I can't quite figure out what your intention for "works" is :-). -scott On Sat, May 17, 2008 at 12:49 AM, Mike Marshall <[EMAIL PROTECTED]> wrote: > I have an FTS3 table created as follows > > > > CREATE VIRTUAL TABLE data USING fts3(guid, text) > > > > And a standard table created thus > > > > CREATE TABLE category (label, query) > > > > > > What I would like to be able to do is an SQL query of the form > > > > SELECT guid FROM data WHERE text MATCH SELECT query FROM category > > > > But I can't seem to get it to work. > > > > Should it work? And if it should can someone point out what I am doing > wrong. > > > > Thanks > > > > Mike > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
