For examples, lets say I need to do set operations and joins on below result sets from 3 different SQL queries:
- I don't want to write a composite query with subqueries, or use temporary database tables, views or CTEs. In other words, no processing on the database server but on the client machine.
- I am not asking about GUI based query builders like SQLyog
Something which would enable faster data analysis using broken-down sets of data like below from a large database. It could be roughly like if you could join two result sets from two separate queries in Toad/SQL developer. (What I find myself doing now to achieve this is pasting multiple sets of data from each of these queries into MS excel and use vlookup() and further filtering etc.)
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 operation to be done on T1,T2,T3 from above 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 generates SQL like above to process on top of the result sets, SQL above is only for conveying the logic I have in mind.)
Required result is:
Col1 Col4 1 #
This was previously asked here on DBA.SE and has been migrated by the OP.