>>>cKey Desc >>>'1' one >>>'2' two >>>>>>
>>>SELECT file1.*, '1' cKey, ; >>>file2.desc Desc2 ; >>>FROM file1 ; >>>INNER JOIN file2 ; >>>ON file1.cKey = file2.cKey ; >>>INTO CURSOR c1 >>>>>>
>>>Fields from file1 Desc2 >>>... ... ... ... one >>>... ... ... ... one >>>... ... ... ... one >>>>>>
>>select file1.*, file2.* >>from file1, file2 >>where file2.cKey = '1'>
>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.