>SELECT NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,1 AS ORDERF ; > FROM THREAD WHERE NoClient=5 AND NUMERO>=600000; >UNION SELECT NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,0 AS ORDERF; > FROM THREAD WHERE NoClient<>5 AND NUMERO>=600000; > ORDER BY ORDERF DESCENDING,NOCLIENT,NOCAT,NOTHREAD,NOPARENT INTO CURSOR TEMP READWRITE >Did you try that? This is not supported with UNION.