Igor Tandetnik wrote...
On 1/23/2014 2:11 PM, jose isaias cabrera wrote:
SELECT * FROM A WHERE projid = (SELECT projid FROM B WHERE ptask = 'a');
You want
WHERE projid IN (SELECT ...)
IN operator accepts a set on the right; = operator only accepts a scalar
(which comes from the first row of the sub-select).
Thanks, Igor. Someday, I want to be like you. :-)
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
