topic Re: InnerJoin? in Application Development and Automation Discussions

InnerJoin?

Former Member — Thu, 20 Sep 2007 20:35:25 GMT

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.

Re: InnerJoin?

ferry_lianto — Thu, 20 Sep 2007 20:38:47 GMT

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

Re: InnerJoin?

Former Member — Thu, 20 Sep 2007 20:39:07 GMT

It's INNER JOIN, not INNERJOIN.

Rob

Re: InnerJoin?

Former Member — Thu, 20 Sep 2007 20:40:10 GMT

Hi Rob,

Thanks,

Gopi.

Re: InnerJoin?

ferry_lianto — Thu, 20 Sep 2007 20:42:52 GMT

Hi,

Did you check my reply? Anything wrong?

Regards,

Ferry Lianto

Re: InnerJoin?

Former Member — Thu, 20 Sep 2007 20:51:03 GMT

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

Re: InnerJoin?

Former Member — Thu, 20 Sep 2007 20:52:52 GMT

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

there is no space between inner join..