All, I don't know if I can do this.
I have a table T1 with Sentences and a table T2 with Terms. If I want to find all Sentences with the term "GM" I search like this: SELECT [Sentences] FROM [T1] WHERE [Sentences] LIKE '%GM%'; What I would like to do is look for all terms that appear in the Terms table. Something like this (but of course this does not work): SELECT [Sentences] FROM [T1] WHERE [Sentences] LIKE (SELECT Terms FROM T2); So my question is: can this be done, and if so, how? thanks Gert _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
