>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'
If it's not broken, fix it until it is.
My Blog