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