[sqlite] Equiv stmts, different explain plans

[Kyle]

On another DB I came across 2 stmts, that I think are equivalent, but 
generated different explain plans. I request a second opinion - are 
these 2 stmts equivalent? If so, why do they generate different explain 
plans even on sqlite?
TIA
--
create table t1(c,d);
create table t2(c,d);
explain select * from t1
  where c=1 and d in (select d from t2 where c=1);
explain select * from t1
  where c=1 and d in (select d from t2 where t2.c=t1.c);
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users