Skip to Content
0
Former Member
Feb 18, 2009 at 06:50 PM

Avoid inner Join Between likpuk and lipsup

101 Views

Hi ,

i am using an inner join Between likpuk and lipsup, but its taking lot of time to execute,

the inner join is between two views, is there any other way to get the same what i am getting from the below inner join..

SELECT avbeln bmatnr bwerks blgort b~charg FROM likpuk AS a INNER JOIN lipsup AS b

ON avbeln = bvbeln INTO TABLE tb_delivery

WHERE akostk = 'C' AND bwbsta NE 'C' .

thanks in advance,

vinayaka

Move to correct forum

Edited by: Rob Burbank on Feb 18, 2009 1:55 PM