Hi,
The documentation mentions the possibility of joining a fts table with a normal
table via rowid.
(e.g. select sender, subject from email join email_text on email.rowid =
email_text.rowid where body match 'jam';)
Can this join only be done via the rowid field? I tried using an
"id" field (my own id INTEGER field) - i.e when I insert the fts
record, I set the rowid to id of the other table, and then tried join
with e.g. email.rowid = email_text.id, but get an error. It seems this is not
possible, but I'm not sure why there should be a distinction.
Thanks
Rael
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
