Fabio,

That does not work. It only opens myview aliased as 'anothername'.

My problem is not the alias of the view itself. My problem is the fact that the lookup table is only opened ONCE and not two times with the alises that I want!

Regards,

Mike


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

>USE(mydbc!myview) in 0 again alias 'anothername'
>

>
>Fabio