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