Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

select from 6 table into internal table

Former Member
0 Kudos
108

hi,

i want to fetch datas from 6 tables to be displayed in one list or grid display.

In which 3 of the tables share a common field and other 3 doesnt relate each other.

So,

i have decided to have inner join for 3 tables first.

Then to use 3 select statements to append in to 3 new internal table using for all entries.

can some one help me out?

rewards for succesful suggestions.

1 ACCEPTED SOLUTION

Former Member
0 Kudos
60

You can take care some of the points.

1. After the Inner join SORT the internal table.

2. If the table that you will use after this join has a field that is primary key and is having in the table coming from join, you can you DELETE ADJACENT DUPLICATE.

Check whether the internal table is filled before the next select if you are using FOR ALL ENTRIES.

Mukesh KUmar

5 REPLIES 5

Former Member
0 Kudos
61

You can take care some of the points.

1. After the Inner join SORT the internal table.

2. If the table that you will use after this join has a field that is primary key and is having in the table coming from join, you can you DELETE ADJACENT DUPLICATE.

Check whether the internal table is filled before the next select if you are using FOR ALL ENTRIES.

Mukesh KUmar

Former Member
0 Kudos
60

Hi Kumar,

As you said there is not relation between 3 other tables, How are you going to use for all entries?

What are that tables?

Regards,

Satish

0 Kudos
60

hi,

help me to check the entries and make the list out of 6 tables with 3 of them dont have relationship?

shall i append it by entering for all entries?

Former Member
0 Kudos
60

i have combined 2 tables using one inner join, and other 2 tables using other inner join.

i want to combine both the contents of 2 internal tables into one table.

but the fields r over coming other values, bcos both have one field in common from different tables.

help me in these issue.

Former Member
0 Kudos
60

Its fine that you guys did some useful things in helping me.

thank you