Skip to Content
0
Former Member
Dec 22, 2008 at 01:51 AM

temporary table

24 Views

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