Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

InnerJoin?

Former Member
0 Kudos

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 aBWKEY aBUKRS b~WAERS into table i_T001K_out

From T001K as a

InnerJoin T001 as b on aBUKRS = bBUKRS ."

Error : "Wrong Expression INNERJOIN in FROM Clause"

Thanks,

Gopi.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

It's INNER JOIN, not INNERJOIN.

Rob

6 REPLIES 6

ferry_lianto
Active Contributor
0 Kudos

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
0 Kudos

It's INNER JOIN, not INNERJOIN.

Rob

0 Kudos

Hi Rob,

Thanks,

Gopi.

ferry_lianto
Active Contributor
0 Kudos

Hi,

Did you check my reply? Anything wrong?

Regards,

Ferry Lianto

Former Member
0 Kudos

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

Former Member
0 Kudos

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

there is no space between inner join..