I read with more attention.

>How can I force the view to be opened with the correct aliases the way the "Run Query" does it?

USE(mydbc!TAB_LOOK) in 0 again alias 'TL_1'
USE(mydbc!TAB_LOOK) in 0 again alias 'TL_2'
USE(mydbc!TAB_MAIN) in 0

>Why is it different?

Because "Run Query" open the list tables of the view.
The USE command do this:
- if the tables of the query are not open, it open the tables
- execute the query without use other static workareas ( use temp workareas )


Fabio