InnerJoin?

[Former Member]

Hi Guys ,

In my application i have to join 2 tables T001K and T001 and keep it in the Final Internal table whos structure contains fields like T001K-BWKEY, T001K-BUKRS and T001-WAERS.My logic is like this but i am getting error.

" Select a_{BWKEY a}BUKRS b~WAERS into table i_T001K_out

From T001K as a

InnerJoin T001 as b on a_{BUKRS = b}BUKRS ."

Error : "Wrong Expression INNERJOIN in FROM Clause"

Thanks,

Gopi.

[ferry_lianto]

Hi,

Please try this.

Select a~BWKEY a~BUKRS b~WAERS 
INTO TABLE i_T001K_out
From T001K as a 
Inner Join T001 as b on a~BUKRS = b~BUKRS  "Put space between inner and join
WHERE <...>.

Regards,

Ferry Lianto

[Former Member]

It's INNER JOIN, not INNERJOIN.

Rob

[Former Member]

Hi Rob,

Thanks,

Gopi.

[ferry_lianto]

Hi,

Did you check my reply? Anything wrong?

Regards,

Ferry Lianto

[Former Member]

bukrs is not a primary key in t001k.that's why it is giving as wrong expression.

[Former Member]

sorry above thing is wrong i'e bukrs primary key.

there is no space between inner join..