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

Use NOT EXISTS, e.g.

SELECT * FROM A WHERE NOT EXISTS (SELECT 1 FROM B where ;

A.Column2 = B.Column2 and A.Column6 = B.Column6) INTO CURSOR MUCUR1 NOFILTER