Skip to Content
0
Former Member
May 10, 2008 at 11:47 AM

How to Get the data from 5 tables?

67 Views

Hi Experts,

i got a Requirement in that, i want to get data from 5 tables into one internal table. but here i want to get the data like:

suppose there are 5tables like tab1,tab,tab3,tab4 and tab5.

in first querry i want to get data from tab1,tab2 and tab5 into i_tab. Then

in 2nd querry i want to get data frm tab1,tab2, tab3 and tab5 and append into i_tab only, Then

in 3rd querry i want to get tab1,tab2,tab4 and tab5 and append into i_tab.

here my dought is how can i append 2nd and 3rd querry data into i_tab.

Thanks in advance,

sudeer.