Inner join statement

[Former Member]

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?

[Former Member]

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?

[Former Member]

Hi,

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

Best Regards,

Suresh

[Former Member]

Sorry, meanwhile I solved it

[former_member15255]

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