Ordered INSERT...INTO or UPDATE

From: Starman <ninomail_at_tin.it>
Date: Wed, 1 Dec 1999 17:25:55 +0100
Message-ID: <823i7j$r0e$1@aquila.tiscalinet.it>

In there a way to insert data from a table o another ordering data?

For example I have a table containing:

Number

---

40
10
20
30

I want to insert in another table:

Number

---

10
20
30
40

Another solution is to have another field (ord for example) for ordering data. But how can I do an UPDATE setting the order in this field from smaller to bigger number?

Help me please!

--
Nino Stella
Inteldata Srl
email: ninomail_at_tin.it Received on Wed Dec 01 1999 - 10:25:55 CST