Probably won't help but the final one works with SELECT in double brackets

SELECT * FROM x 
JOIN y ON y.a = x.a 
WHERE (x.a, x.b) IN ( ( SELECT a, b FROM z ) ); 
.




--
Sent from: http://sqlite.1065341.n5.nabble.com/
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to