General information
Category:
Coding, syntax & commands
Title:
Selecting same table from different folders
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only