You can use the alias rather than the dbf name in the FROM clause of your SQL view. When you say you can't edit the SQL view you mean at run time, I hope.

>The problem with that solution is that I need the query to run so that it will produce a output table from the query results. I can not edit in the SQL view - Is there a way that I can eliminate the table (plus path of table) name and only have the ALIAS named in the SQL view. Thanks in advance.
>
>
>Carl