HELP REQ IN FOR ALL ENTRIES STATMENT

[Former Member]

Hi all,

HELP ME OUT REGARDING THIS

select * into table itab

from zxxx

for all entries in i_tab1

where order = i_tab1-ORDER.

****here i have 10 records in itab

select * into table itab

from zxxx

for all entries in i_tab2

where USERID = i_TAB2-USERID.

*here i have 5 records.

combine together i have 15 records. I need 15 records.

Is there a way for this.

[Former Member]

select * into table itab

from zxxx

for all entries in i_tab1

where order = i_tab1-ORDER.

for the second select make a small change

****here i have 10 records in itab

select * <b>appending</b> table itab

from zxxx

for all entries in i_tab2

where USERID = i_TAB2-USERID.

[Former Member]

Hi,

Use the <b>appending</b> instead of the <b>into</b> for the second "select".

Regards,

Erwan

[Former Member]

Append lines of itab2 to itab1.

Then use a single select:

select * into table itab

from zxxx

for all entries in i_tab1

where order = i_tab1-ORDER.

Regards,

Prakash.

[Former Member]

Hi Guys,

Thanks for helping me out.

select* appending worked for me.

I HAVE AWARDED POINT TO ALL.

tHANKS