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

Reply via email to