topic Select with Join doesn't work in Application Development and Automation Discussions

Select with Join doesn't work

Former Member — Tue, 20 May 2008 15:21:33 GMT

Hi @ll,

can anybody say why I get the syntax error The column name "VKORG" has two meanings. ABAP/4 Open SQL statement.

Thanks

Kam

SELECT vtweg vmsta mtpos vkorg

FROM MVKE

INNER JOIN YMMARKET_CODE

ON mvke_{vkorg = ymmarket_code}vkorg

INTO CORRESPONDING FIELDS OF TABLE i_mvke

WHERE mvke~matnr = p_matnr.

Re: Select with Join doesn't work

Former Member — Tue, 20 May 2008 15:23:59 GMT

write as:

SELECT vtweg vmsta mtpos

MVKE~vkorg

FROM MVKE

INNER JOIN YMMARKET_CODE

ON mvke_{vkorg = ymmarket_code}vkorg

INTO CORRESPONDING FIELDS OF TABLE i_mvke

WHERE mvke~matnr = p_matnr.

Re: Select with Join doesn't work

Former Member — Tue, 20 May 2008 15:24:51 GMT

Because the column name vkorg has two meanings 😛

It must be either


SELECT vtweg vmsta mtpos mvke~vkorg
FROM MVKE
INNER JOIN YMMARKET_CODE
ON mvke~vkorg = ymmarket_code~vkorg
INTO CORRESPONDING FIELDS OF TABLE i_mvke
WHERE mvke~matnr = p_matnr.


SELECT vtweg vmsta mtpos ymmarket_code~vkorg
FROM MVKE
INNER JOIN YMMARKET_CODE
ON mvke~vkorg = ymmarket_code~vkorg
INTO CORRESPONDING FIELDS OF TABLE i_mvke
WHERE mvke~matnr = p_matnr.

Re: Select with Join doesn't work

Former Member — Tue, 20 May 2008 15:25:00 GMT

hi there...

the error is because in select, the system is unable to make out whose vkorg field u want to fetch as the field exists in both the tables.

Do like this....

select .... a~vkorg from table1 as a inner join table2 as b where......

this will make ur query work....

do reward and close the query or get bak if facing any more issues.

Re: Select with Join doesn't work

Former Member — Tue, 20 May 2008 15:26:10 GMT

try this way...

SELECT a_{vtweg a}vmsta a_{mtpos a}vkorg

INTO CORRESPONDING FIELDS OF TABLE i_mvke

FROM MVKE AS A

INNER JOIN YMMARKET_CODE AS B

ON b_{vkorg = a}vkorg

WHERE a~matnr = p_matnr.

Re: Select with Join doesn't work

Former Member — Tue, 20 May 2008 15:31:31 GMT

Thanks all of you for your help. Issue resolved.