Toad World® Forums

Toad view in a toad view

Hi does anybody know if a can query a toad view within another toad view?. I keep getting the error table not valid thanks

Hey welcome to the TDP forum.

Yes, you should be able to use Toad Views within other Toad View definitions. You might need to be careful to alias your tables or even the Toad Views themselves when nesting. In the example below, I created two Toad Views, and then created a third Toad View that accesses each of the other two, but I had to alias the other Toad Views to get this to work properly.

Hope this gives you some ideas.

1 Like