On Thursday 07 July 2005 04:13 pm, Marvin Bellamy wrote: > Thanks for the join tip. This must be a 3.2.1-specific bug, because > that last example doesn't work for me. Looks like its been reported > already.
Oops.. guess I missed that. this works great: sqlite> create view v2 as select a.id as "id", b.name as "name" from t1 a inner join t2 b on a.id=b.id; simply give them an alias. sqlite> select * from v2 where id=1; id|name 1|foo this is also using 3.2.1