topic Re: select from 6 table into internal table in Application Development and Automation Discussions

select from 6 table into internal table

Former Member — Sat, 15 Dec 2007 07:59:43 GMT

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.

Re: select from 6 table into internal table

Former Member — Sat, 15 Dec 2007 08:08:37 GMT

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

Re: select from 6 table into internal table

Former Member — Sat, 15 Dec 2007 09:35:10 GMT

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

Re: select from 6 table into internal table

Former Member — Mon, 17 Dec 2007 07:04:53 GMT

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?

Re: select from 6 table into internal table

Former Member — Thu, 20 Dec 2007 15:26:24 GMT

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.

Re: select from 6 table into internal table

Former Member — Fri, 28 Dec 2007 06:13:22 GMT

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

thank you