Bingo! Thanks you all!
2013/3/26 Clemens Ladisch <clem...@ladisch.de>: > Gert Van Assche wrote: >> 2013/3/26 Clemens Ladisch <clem...@ladisch.de>: >>> 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 >> >> 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. > > That's how you wrote it in your original query... > > Just add wildcards around the terms: > > SELECT Sentences FROM T1 JOIN T2 ON T1.Sentences LIKE '%' || T2.Terms || '%' > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users