See what happens if you add the "AS" keyword: ... '1' AS cKey

This should be implicit, but if I remember correctly, older versions of Visual FoxPro interpret:
'1' cKey
as:
'1', cKey
rather than supplying the AS keyword which should be implicit.

>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