Yes but then I must repeat the column names in every query in which I use the view. It is a bug in SQLite, isn't it?
Jakub Brass Tilde ([EMAIL PROTECTED]) wrote*: > > > 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; > > Change this last line to: > > create table problem as select a as a from myview; > > That creates the problem table with just "a" as the field name. >