select from 6 table into internal table

[Former Member]

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.

[Former Member]

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]

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

[Former Member]

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]

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]

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

thank you