Thanks Fabio.
I like the way the "Run Query" works. It opens the tables with the correct aliases automatically. Now I have to add more code to my app to do this correctly with USE(). Arrrrggghhhhh...:(
Mike
>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