join using native sql

[rupali_bhalerao]

hi experts,

i want to know that join is possible in natine sql?

if i want to join mara & makt then how i suppose to do?

pls do the needful.

thanx in advance.

[Former Member]

HI,

Please seach the scn to have more knowledge on Joins

Select a~matnr b~maktx 
from mara as a 
Inner join Makt as b
on A~matnr eq b~matnr
into table itab

.

[Former Member]

refer this link

https://www.sdn.sap.com/irj/scn/forums