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