Also, the data types (in 2.8.15) do not appear to copy over into the newly created table...
I had to manually create the table with SQL, then insert into it from the query. -----Original Message----- From: Jakub Ad�mek [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 3:08 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] coding style 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. >
