temporary table

[Former Member]

Hi expert

How can i modify or change this SQL use inner join?

loop at ta_cust2.

l_index1 = sy-tabix.

read table ta_ymeq with key plnnr = ta_cust2-plnnr.

if sy-subrc <> 0.

delete ta_cust2 index l_index1.

else.

clear ta_cust2.

endif.

endloop.

i want to select the record in ta_cust2 inner join ta_ymeq key plnnr

Edited by: Fidah on Dec 22, 2008 3:09 AM

[Former Member]

Do search query like below:

SELECT field1 field2 FROM Table APPENDING TABLE ta_cust2

FOR ALL ENTRIES IN ta_ymeq WHERE plnnr = ta_ymeq-plnnr.

[Former Member]

the SQL select want we put the original table in FROM table how about i want to get it from temporary table?

[Former Member]

You cannot use SQL statement on Temporary table.

You can use Append statement after reading the tempory table with key plnnr.

[Former Member]

oic. how can i modify the read table statement to add inner join ? i try but still error..