On 1/23/2014 2:26 PM, St. B. wrote:
SELECT * FROM A WHERE projid in (SELECT projid FROM B WHERE ptask = 'a');
will probably fill the bill.
If I where to run your query, I would do a
select A.* from A inner join B on A.a = b.ProjId where b.ptask='a'
Careful - this will produce a different result if B has multiple rows
with the same ptask and projid. May or may not be a concern in the OP's
case.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
