Hi according to the documentation - 6.2.2. External Content FTS4 Tables
An "external content" FTS4 table is similar to a contentless table, except that if evaluation of a query requires the value of a column other than docid, FTS4 attempts to retrieve that value from a table (or view, or virtual table) nominated by the user (hereafter referred to as the "content table"). However I see no example for a query on the fts table that implicitly retrieves values from the content table, nor could I find any in other place. All my attempts to write such a query ended up with "Error: no such column". Am I missing something or is it a problem in the documentation? Thanks _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users