Hello, I try to copy one table into a second identical one. Once the second table is created I want to move the content over sorted by ASC.
The issue is that the ORDER BY statement gets ignored during a INSERT INTO: INSERT INTO CompanyDetails2 SELECT * FROM CompanyDetails WHERE CompanyDetails.ID > 0 ORDER BY CompanyDetails.RIC ASC When the SELECT query is executed alone, the content is sorted fine as expected. Andre _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users