I have two Select queries.
The first Select query gives the output which has two columns viz.
A B ------ 1 2 3 4 5 6 7 8
The second Select query given the output which as two columns viz Column B and Column C. All the values in Column B of this select statement matches the values of Column B of the first Select statement.i.e
B C ------ 2 25 4 50 6 30 8 50
Now, I need to merge the outputs of the above two Select queries. i.e
A B C ---------- 1 2 25 3 4 50 5 6 30 7 8 50
I cannot use views to store the output of the two select queries. I need to use the Column B in both select queries to merge. However, I am not able to figure out how to go about it.
If you have elaborated queries (not just tables to join), you may try using
with Query1 as ( -- <- Put your 1st Query text here select A, B ... ), Query2 as ( -- <- Put your 2nd Query text here select B, C ... ) select Query1.A, Query1.B, Query2.C from Query1, Query2 where Query1.B = Query2.B
If your case is not that complicated, e.g. both Query1 and Query2 are in fact tables, say
Table2 you can do well with a simpler solution:
select Table1.A, Table1.B, Table2.C from Table1, Table2 where Table1.B = table2.B