For examples, lets say I need to do set operations and joins on below 3 result sets.
I don't want to write a composite query or use temporary database tables. Something which would enable faster data analysis using broken-down sets of data like below from a large database. Like as if you could join two result sets in toad or SQL developer with the help of a GUI.
SQL Query 1 result: (T1)
Col1 Col2 A 1 B 2
Query 2 result: (T2)
Col3 Col4 1 # 2 *
Query 3 result: (T3)
Col5 1 3
Required output is
Select T1.col1,T2.col4 from T1,T2 where T1.col2=T2.col3 and T1.col2 in (Select T3.col5 from T3)
(Not necessary that the tool should generate SQL like above to process the result sets, SQL is only for conveying the logic.)
Col1 Col4 1 #