I am creating a in house utitity that will allow a field comparison of two selected tables or Queries. The problem I am running into is when an ALIAS is selected for use in the Query and you save and modify in the Query Designer. If you look into the SQL view and it has the name of the original table name plus the ALIAS name. When you run the QPR it looks for the original table. For me that's a big problem and since SQL view is read only I am unable to modified it. Does anyone know of a way around it. Thanks in advance

Example :
SELECT *;
FROM somast01 A_tmpnew;
ORDER BY A_tmpnew.sono;
INTO TABLE test1.dbf