Without it, it will create an index on table A with the TAG of TEST2, try it.

>The added line is redundant.
>
>>>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