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.