>>The version of Btrieve that I'm working with as a back end to my VFP front end doesn't support JOINs according to it's help file. How could I accomplish the following without using a JOIN?
>>
>>SELECT TableA.Field1 + TableB.Field2 FROM TableA JOIN TableB ON TableA.Field1 = TableB.Field3
>>
>Bob,
>
>
>SELECT TableA.Field1 + TableB.Field2 ;
> FROM TableA, TableB ;
> WHERE TableA.Field1 = TableB.Field3
>
Thanks Jim. I got into SQL after the JOIN was invented, and got a bit spoiled. With your help, this blast of (now obvious) insite moves me one notch higher.
Bob