It's normal behavior for a query because you can either specify a table name or an alias. 'BFolder\Kfitr' is a table name. 'Kfitr' could be either an alias or table name. VFP first looks for an alias and if not found, for the table name. './Kfitr' would be correct way to specify that you're looking for the table name in the current directory.

>Figure this out.
>It would seem that if you ahve a Select from and include a Subfolder, unless you close all all subsequent selcts seem to use the table in the subfolder, even thouh you specify the table without a sub folder...strange behavior !!!
>Regards,
>Gerard
>
>
>
>
>>I am trying to determine if a partcular filed is the same for two identically named tables, on in the current folder and one ina subfolder. but the result of my seletion gives all records in the sub folder
>>
>>File name is KFITR which is in the current folder and also an identical Table named KFITR in a folder underneath called BFolder
>>
>>SELECT ;
>> BB.Fielda as BLink , AA.Fielda as ALink ;
>> FROM BFolder\Kfitr BB ;
>> JOIN Kfitr AA ON BB.FieldA = AA.FieldA ;
>> INTO Dbf Temp1
>>IF RECCOUNT() > 0
>> WAIT WINDOW 'There is a clash of Itrlink from Omega Itr and Zeus Itr'
>>ENDIF
>>
>>Even though there are no duplicate records, I get ALL the records from the BB folder whereas I would have expected no records in Temp1
>>
>>Tia
>>Gerard