query

Hi experts,

Can you please convert this query from inner join to for all entries in statement query.

***********************************

SELECT v_{vbeln v}vdatu v_{kunnr v}erdat

p_{posnr p}matnr p~kwmeng

INTO CORRESPONDING FIELDS OF TABLE it_tab1

FROM vbak AS v

INNER JOIN vbap AS p

ON p_{vbeln = v}vbeln

WHERE v~vbeln IN s_vbeln

AND v~kunnr IN s_kunnr

AND v~erdat IN s_erdat

AND v~vbtyp eq 'C'

AND v~vkorg IN s_vkorg

AND p~matnr IN s_matnr

AND p~vstel EQ s_vstel.

*************************************************

Change this in to for all entries in ,please help me.