>>Brett,
>>MDB driver supports joins. You could write the SQL in its designer and copy (as I did). Its designer have more capabilities then VFP's.
>>Cetin
>
>
>I tried that several times and the designer would represent what I want. Joins and all, but when I told it to exectute the SQL (that it built visually) then ODBC would error out. I figure it is about the same principle as VFP's query designer. It is good until you push the envelope a little and then it creates SQL code that cant be run either.

Might be:) I was going nuts till I discovered it wants parentheses.
Cetin