[sqlite] conditional queries against views

[Marvin Bellamy]

Can anyone explain why these queries don't work?  And, is there a 
workaround?

create table t1 (id int);
create table t2 (id int, name varchar(32));
create view v1 as select a.id, b.name from t1 a, t2 b where a.id=b.id;
select * from v1 where a.id=1;
select * from v1 where t1.id=1;
select * from v1 where t2.id=1;
select * from v1 where id=1;

--
Marvin Keith Bellamy
Software Engineer
Innovision Corporation
913.438.3200