>i try as below not match , another select not work
>all fields is chr type
>

>CLOSE ALL
>USE A
>INDEX ON COLUMN2+COLUMN4+COLUMN9 TAG TEST1
>BROWSE
>USE B

SELECT B && Add this

>INDEX ON COLUMN2+COLUMN4+COLUMN9 TAG TEST2
>BROW
>SELECT * FROM A WHERE COLUMN2 NOT IN (SELECT COLUMN2 FROM B) INTO CURSOR MUCUR1&& no result
>
>SELECT * FROM A WHERE COLUMN2,COLUMN6  NOT IN (SELECT COLUMN2,COLUMN6 FROM B) INTO CURSOR MUCUR1&& error 
>

>thanks