>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

select file1.*, file2.*
from file1, file2 
where file2.cKey = '1'