Re: [sqlite] Fetching records from Temp table

On 5/22/08, Farzana <[EMAIL PROTECTED]> wrote: > > Dear All, > > We have a table named Brand(data is not ordered by Branddescription) where > BrandDescription is one of the column and we tried to copy the Brand with > the same stucture with the table name Brand_temp and inserted the data >

Re: [sqlite] Fetching records from Temp table

"Farzana" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > CREATE TABLE Brand_temp AS SELECT * FROM Brand WHERE 1=2 > insert into Brand_temp select * from brand order by branddescription > > Then we dropped the Brand table and renamed the temp table as brand > like as follows: > Drop

[sqlite] Fetching records from Temp table

Dear All, We have a table named Brand(data is not ordered by Branddescription) where BrandDescription is one of the column and we tried to copy the Brand with the same stucture with the table name Brand_temp and inserted the data ordered by BrandDescription into a temp table as follows: CREATE