Use query from another query
Hello.
I want to use or call a query I created, from a new query, like if it was a table. Something like this -->
Query Base
Select * from table1
Query New
Select * from Base
where Base.Id = 2
This is just an example, what I need to do is much more complicated, but I thought I could use my owns queries like any table from my database, and it doesn`t work. Is there something I need to do to have this option? or is just not possible to do it.
I want to use or call a query I created, from a new query, like if it was a table. Something like this -->
Query Base
Select * from table1
Query New
Select * from Base
where Base.Id = 2
This is just an example, what I need to do is much more complicated, but I thought I could use my owns queries like any table from my database, and it doesn`t work. Is there something I need to do to have this option? or is just not possible to do it.