topic Re: Inner join statement in Application Development and Automation Discussions

Inner join statement

Former Member — Wed, 08 Apr 2009 10:16:35 GMT

Hi experts,

I have a selection with inner join and I have to provide the field names which I want to select. One of the fieldnames is the same as in the join table. Syntax check says that "the column name is unclear.

How can is fix this problem?

Re: Inner join statement

Former Member — Wed, 08 Apr 2009 10:21:47 GMT

Hi,

Could you please brief your problem with the code...? Because your question is not clear..

Best Regards,

Suresh

Re: Inner join statement

Former Member — Wed, 08 Apr 2009 10:25:05 GMT

Sorry, meanwhile I solved it

Re: Inner join statement

former_member15255 — Wed, 08 Apr 2009 10:27:55 GMT

Hello,

As the fields is available in both the tables it should be aliased for example

select a_{matnr from mara as a inner join makt as b on a}matnr eq b~matnr

where a~matnr in so_matnr

regards

Suresh Nair