A late Thank you!

>VFP cannot create filtered cursor when query involves more than one table. Basic requirements for filtered cursor:
>- Only one table is referenced by query
>- WHERE condition is optimisable and can be represented by SET FILTER TO
>- Either all fileds from the table are selected or subset of fields can be limited by SET FIELDS command
>
>
>
>>Thanks. In fact the VFP help says:
>>
>>

>>NOFILTER creates a cursor that can be used in subsequent queries.
>>

>>
>>So why does this work:
>>
>>

>>SELECT Lotmast.lm_flcode FROM ;
>>    it!lotmast ;
>>    INNER JOIN it!flckmast ;
>>   ON  Lotmast.lm_flcode = Flckmast.fm_flcode ;
>>   WHERE SUBSTR(lm_flcode,5,4) >= '2026' ;
>>   INTO CURSOR curs1
>>
>>  SELECT * ;
>>  fROM curs1 ;
>>  INTO CURSOR curs1a
>>

>>
>>Thanx-
>>Yossi