Jim Booth gave you the solution. Another way of doing such things (when you're using an ODBC connection) is to design your SELECT in the Query Designer against your specific data source and copy&paste the generated SELECT. The generated select is compatible with your ODBC source (I mean that it may be different for different types of databases). So, you can see the proper syntax.

Other query builders (like the one in Interdev) will generate similar SELECT statements.

Vlad

>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