On 19 Mar 2014, at 7:50pm, Sander Jansen <s.jan...@gmail.com> wrote:
> SELECT * FROM tracks WHERE (SELECT id FROM artists WHERE name LIKE 'John > Williams') IN (performer,conductor,composer); The art of using JOIN is obviously dead. The is a classic case of a UNION of three JOINs. Also, don't forget to create an index on the TABLE tracks for each of its FOREIGN KEYs. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users