inner join

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

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

[Former Member]

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 <b>on<condition></b> where a_{kunag in s_kunag and b}create_date

in s_fkdat.

[Former Member]

Hi Siva,

What is the error you are getting ?

Use <b>Inner Join as</b>

INNER JOIN AS a ON <i>conditions</i>

AND <i>conditions</i>

AND <i>conditions</i>)

Regards

Kannaiah

[Former Member]

Hi

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

<b>condition</b>

where a_{kunag in s_kunag and b}create_date

in s_fkdat

Regards

Shiva

[Former Member]

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