>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.
>
Generate the query as normal, then do a
modify command myquery.qpr What I am saying is you can accomplish everything you want just by editing the generated code. There is no difference between a QPR and a PRG. However, once you modify the QPR, you probably will have difficulty opening it in the designer. But, you can cut and paste the code from the QPR into a PRG everytime you modify the query. Then just run the PRG. You can actually put any code in the QPR and compile it, and it will run [assuming no syntax errors, etc., of course].
Mark McCasland
Midlothian, TX USA