>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.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope