On 3/19/2014 3:50 PM, Sander Jansen wrote:
What does the EXECUTE LIST and EXECUTE SCALAR mean?
A subquery is a select statement enclosed in parentheses. It's a list
subquery if it's a right-hand-side operand of IN or NOT IN operators,
and a scalar subquery otherwise (because only a single value from the
first column of the first row is actually used).
By the way, (1) and (2) are not equivalent. If there is more than one
artist matching the name, (1) chooses only one artist in an
unpredictable manner, while (2) would find tracks for all of them.
Another way to formulate your request might look like this:
SELECT tracks.* FROM tracks join artists on (id=performer or
id=conductor or id=composer)
where name LIKE 'John Williams';
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users