actually what is your output requirement...?
you want to generate an out put by combining all the tables like,
table1_col1 ,t1_c2 ,t2_c1,t2_c2,....like this or any other else..?
1 person found this helpful
You can create a query like this:
select * from (
select 1 sort_order, * from t1
select 2, * from t5
select 3, * from t2
order by sort_order, <something else if needed>
Ya . I wanted to join all the tables and make it in one report. I got to know how to make it. I learnt it myself. Thank You SaisandeepT.
Thank You InoL .