topic Re: join using native sql in Application Development and Automation Discussions

join using native sql

rupali_bhalerao — Wed, 21 Jan 2009 11:59:12 GMT

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 — Wed, 21 Jan 2009 12:01:11 GMT

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 — Wed, 21 Jan 2009 12:01:29 GMT

refer this link