SELECT NOCLIENT AS O_NOCLIENT ,NOCAT AS O_NOCAT,NUMERO,NOMEMBER,NOPARENT AS O_NOPARENT,NOTHREAD AS O_NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,1 AS ORDERF ; FROM THREAD WHERE NoClient=5 AND NUMERO>=600000; UNION SELECT NOCLIENT AS O_NOCLIENT ,NOCAT AS O_NOCAT,NUMERO,NOMEMBER,NOPARENT AS O_NOPARENT,NOTHREAD AS O_NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,0 AS ORDERF; FROM THREAD WHERE NoClient<>5 AND NUMERO>=600000; ORDER BY ORDERF DESCENDING,O_NOCLIENT,O_NOCAT,O_NOTHREAD,O_NOPARENT INTO CURSOR TEMP READWRITESo If you wish to use order by with names you should have additional AS clauses with names different from your field names.
Make solutions, not programs!