Re: [sqlite] coding style

[Jakub Adamek]

Hi all, I have a nasty problem with VIEWs and column names. I create a 
VIEW by joining two tables. If I use this view to create the table 
'problem', the column name "t1.a" appears instead of the expected (and 
needed) "a".
Is it a bug? Do you have an idea how to use the view so as it works?

Thanks, Jakub
create table t1 (a,b);
create table t2 (a,c);
insert into t1 values (1,2);
insert into t2 values (1,3);
create view myview as select t1.a a from t1 inner join t2 on t1.a=t2.a;
create table problem as select * from myview;