Come posso ordinare per il campo ORDINE 10 select in questo modo??:

1
2
3
100
200
300
1000

etc?


codice:
SQL = ""
SQL = SQL & " SELECT * FROM AUTORI TA , "
SQL = SQL & " ("
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori1 WHERE Topic LIKE '%" & sTopic & "%'"
SQL = SQL & " union all "
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori2 where Topic LIKE '%" & sTopic & "%' "
SQL = SQL & " union all"
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori3 where Topic LIKE '%" & sTopic & "%' "
SQL = SQL & " union all"
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori4 where Topic LIKE '%" & sTopic & "%' "
SQL = SQL & " union all"
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori5 where Topic LIKE '%" & sTopic & "%' "
SQL = SQL & " union all"
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori6 where Topic LIKE '%" & sTopic & "%' "
SQL = SQL & " union all"
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori7 where Topic LIKE '%" & sTopic & "%' "
SQL = SQL & " union all"
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori8 where Topic LIKE '%" & sTopic & "%' "
SQL = SQL & " union all"
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori9 where Topic LIKE '%" & sTopic & "%' "
SQL = SQL & " union all"
SQL = SQL & " select Topic, id, Title_of_paper, ordine from autori10 where Topic LIKE '%" & sTopic & "%' "
SQL = SQL & " ) TT "
SQL = SQL & " WHERE TA.id = TT.id "
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 3, 3
Grazie per l'aiuto.
G.