>SELECT NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,1; > FROM THREAD WHERE NoClient=5 AND NUMERO>=600000; >UNION SELECT NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,0; > FROM THREAD WHERE NoClient<>5 AND NUMERO>=600000; > ORDER BY 11 DESCENDING,1,2,6,5 INTO CURSOR TEMP READWRITE >>
SELECT distinct NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,; NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,iif(NoClient=5,1,0) as myExp ; FROM THREAD WHERE NUMERO>=600000 ; ORDER BY 11 DESCENDING,1,2,6,5 INTO CURSOR TEMP READWRITECetin