Hi All:

This is file2:

cKey     Desc
'1'          one
'2'          two

I want to run an SQL statement, something like this:

SELECT file1.*, '1' cKey, ;
file2.desc Desc2 ;
FROM file1 ;
INNER JOIN file2 ;
ON file1.cKey = file2.cKey ;
INTO CURSOR c1

that will produce the following:

Fields from file1     Desc2
... ... ... ...               one
... ... ... ...               one
... ... ... ...               one

The problem is that I get a message that 'Column ckey is not found'

Please note that I obviously want the most elegant solution, but if necessary, please give a solution that will work in VFP 5.0.

Thanks,

Yossi