Naoto,
Actually, this is the 2nd time that we have been 'caught' with this type of SQL statement in different places in this same app.
We decided to throw the towel in (due to time constraints) this morning and construct the SQL statement another way.
I * have * archived your message though and might have to refer to it in the future :(.
Thanks for the help.
>If you're talking about FP or VFP tables, then the SET PATH will affect the visibility of the tables. A SET PATH may be making a table visible in your development environment, while on the customer's computer or in a compiled app, the tables may not be accessible in the "current" directory.