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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users