>>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 READWRITE >Cetin