GB wrote:
> we are facing some Problems with Queries joining several FTS-Tables.
FTS tables cannot do efficient lookups except by docid or by MATCHing.
If you have to do joins with other tables, you typically set the docid
in the FTS table to some primary/foreign key in the other tables, and
then use the docids returned from some MATCH:
SELECT ... FROM ...
WHERE ... MyTable.SomeID IN (SELECT docid
FROM FtsTable
WHERE FtsTable MATCH 'something')
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
