topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Wed, 07 Feb 2007 11:31:03 GMT

select a_{vbeln a}kunag b_{r_desc b}create_date c~name1 into corresponding

fields of table itab from vbrk as a inner join zsdinvrej as b on

a_{vbeln = b}i_vbeln inner join kna1 as c where a_{kunag in s_kunag and b}create_date

in s_fkdat.

this statement show me error

i adding three table plsea help me solve the problem

Re: inner join

Former Member — Wed, 07 Feb 2007 11:33:16 GMT

Hi Siva,

In the statement for the second inner join

inner join kna1 as c

where is the on condition.

Please specify that also and then check.

Regards

Arun

Re: inner join

Former Member — Wed, 07 Feb 2007 11:34:15 GMT

Hi,

the problem is with 'inner join kna1 as c', join contion 'ON' is missing...

Re: inner join

Former Member — Wed, 07 Feb 2007 11:35:29 GMT

hi Siva,

Condition missing

select a_{vbeln a}kunag b_{r_desc b}create_date c~name1 into corresponding

fields of table itab from vbrk as a inner join zsdinvrej as b on

a_{vbeln = b}i_vbeln inner join kna1 as c on<condition> where a_{kunag in s_kunag and b}create_date

in s_fkdat.

Re: inner join

Former Member — Wed, 07 Feb 2007 11:36:40 GMT

Hi Siva,

What is the error you are getting ?

Use Inner Join as

INNER JOIN AS a ON conditions

AND conditions

AND conditions)

Regards

Kannaiah

Re: inner join

Former Member — Wed, 07 Feb 2007 11:41:08 GMT

there is no condition for join 3 on KNA1

put some condition

select a_{vbeln a}kunag b_{r_desc b}create_date c~name1 into corresponding

fields of table itab from vbrk as a inner join zsdinvrej as b on

a_{vbeln = b}i_vbeln inner join kna1 as c on

condition

where a_{kunag in s_kunag and b}create_date

in s_fkdat

Regards

Shiva

Re: inner join

Former Member — Wed, 07 Feb 2007 12:42:05 GMT

try this format....

SELECT <choose entries> INTO CORRESPONDING FIELDS OF TABLE IT FROM <table1> INNER JOIN <table2> ON <join condition> INNER JOIN <table 3> ON <join conditions> WHERE <select conditions>.

with regards

vinayaka