Thanks to all who have replied.

I've done some further investigation in the attempt to narrow the problem.

There apparently is no problem w/ case sensitity in either table name column names or column contents. The following works fine.

select LnAMe from VLnteeR where lnaME='WRighT';

There is no problem with using the reserved word "field". The following works fine.

select * from career where field like 'a%';

There is no problem with the following cross-join.

select vlnteer.*, career.field as cfield from vlnteer join career where autovolno=1960;

But when I try to qualify the join with an 'on' clause as follows:

select vlnteer.*, career.field as cfield from vlnteer join career on vlnteer.career=career.code where autovolno=1960;

I get an MyODBC error "parse error near 'on vlnteer.career=career.code where autovolno=1960'"

Can anyone tell me why I'm having the problem with the on clause?

Thanks for any further help you can provide.

Leny Harris