Clemens, doesn't seem to work... The terms are just a part of the sentence, not a full match. Your query does find full matches.
thanks gert 2013/3/26 Clemens Ladisch <[email protected]>: > Gert Van Assche wrote: >> 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); > > SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE T2.Terms > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
