I thought that the insert doesn't work because I didn't create the table properly or I didn't write the select properly or when inserting maybe I had some syntax problem...
Yes, I think I'll try to solve it another way because I can order the table afterwards

Martijn Tonies <m.tonies@...> escribió:

>So? you create the table and then INSERT from a SELECT?
> If I do that I can't insert it ordered because the insert does not allow

the ORDER BY in the >INSERT

Please explain the point of having an ordered insert?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com






---------------------------------

LLama Gratis a cualquier PC del Mundo.
Llamadas a fijos y móviles desde 1 céntimo por minuto.
http://es.voice.yahoo.com

[Non-text portions of this message have been removed]