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'
the join may optimize better than the in (select ...)
Thanks. I will give this a try also. As we say in the Spanish language:
Muchas gracias.
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
