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