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).
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
