Toad World® Forums

Query as a source

Can builder work between two or more ad hoc queries or does it have to work only against objects in the database?

Example

I would like to make a query of aggregated data
Then hook this aggregated query to another query/table
Join on more than one field
and bring back all in the aggregated query and several fields in the join query/table
I can easily do this in editor with a subquery.

You can do this in either the Classic Toad Data Point interface, or the new WorkBook interface.
In either case, you would need to save the interim query results as either a Toad View, save to Local Storage, or save to Toad Intelligence Central.

Hope this helps.

You can do this via Query Builder as well. Start with your outer/final query, then click this button to add a subquery to the FROM clause. A new window will open, create the subquery, then click back to the outer query and you'll see the subquery there as if it were a table object....join them and you're set.

Capture