topic temporary table in Application Development and Automation Discussions

temporary table

Former Member — Mon, 22 Dec 2008 01:51:27 GMT

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 — Mon, 22 Dec 2008 02:33:21 GMT

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 — Mon, 22 Dec 2008 02:37:37 GMT

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

Former Member — Mon, 22 Dec 2008 02:42:28 GMT

You cannot use SQL statement on Temporary table.

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

Former Member — Mon, 22 Dec 2008 02:45:13 GMT

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