>>>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'

>
>Think you need the join
>

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

File1 doesn't have a cKey column. The way I wrote the query was supposed to create a cross join which is the intention of the query.