topic Re: Inner Join Syntax review in Application Development and Automation Discussions

Inner Join Syntax review

Former Member — Wed, 26 Feb 2014 20:40:27 GMT

Hi All,

I want to select the external material text from twewt table , for the corresponding material in mara , so I wrote a join statement like this -

Select singlep~ewbez into gv_extmatdesc from (twewt as p INNER JOIN mara as c on C~matnr = rm_matnr)

Join is working fine and giving me output but I like to know this is the proper syntax or not

Re: Inner Join Syntax review

Former Member — Wed, 26 Feb 2014 20:52:27 GMT

Hi John,

In your selection query do you have any where clause ?

I can see that you r fetching single record with field EWBEZ ? What is where clause condition for this query ? Since you r fetching single field from TWEWT table why inner join is required ?

Can you paste the full selection query ?

Thanks & Regards,

Arun

Re: Inner Join Syntax review

Former Member — Wed, 26 Feb 2014 21:02:38 GMT

Hi Aruna,

I have only material number value.

so I have to write like I have to fetch twewt-ewbez for mara-extwg when mara-matnr = my_matnr

How Can I achieve this?

Re: Inner Join Syntax review

Former Member — Wed, 26 Feb 2014 21:13:25 GMT

Hi John,

Can you paste full inner join selection query ?

Thanks & Regards,

Arun

Re: Inner Join Syntax review

Former Member — Wed, 26 Feb 2014 21:32:43 GMT

the same as in the first post

Re: Inner Join Syntax review

Former Member — Wed, 26 Feb 2014 22:13:54 GMT

I have done it aruna , thanks