topic Re: select with inner join in Application Development and Automation Discussions

select with inner join

Former Member — Tue, 17 Mar 2009 06:14:22 GMT

hi friends,

can we use where clause in select statement with inner join.

i am using following code which gives error (The column name "WERKS" has two meanings . .).

SELECT A_{MATNR A}CHARG A_{ERSDA B}MENGE B~MEINS

FROM MCHA AS A INNER JOIN CHVW AS B

ON A_{CHARG = B}CHARG

INTO TABLE T_OUTPUT1

WHERE WERKS = PLANT AND CHARG = P_CHARG.

thanks.

Re: select with inner join

Former Member — Tue, 17 Mar 2009 06:16:28 GMT

Yes you can use, the probelm below is both tables has werks and you have to specify which tables.

So in the where condition if you give A-WERKS OR B-WERKS should solve the problem

Mathews

Re: select with inner join

Former Member — Tue, 17 Mar 2009 06:19:07 GMT

Yes you can use it.

In the above where clause give

A-WERKS OR B-WERKS and

A-CHARG OR B-CHARG.

Cheers,

Surinder

Re: select with inner join

Former Member — Tue, 17 Mar 2009 06:20:14 GMT

Yes u can use where clause in select statement with inner join.

SELECT A_{MATNR A}CHARG A_{ERSDA B}MENGE B~MEINS

FROM MCHA AS A INNER JOIN CHVW AS B

ON A_{CHARG = B}CHARG

INTO TABLE T_OUTPUT1

WHERE WERKS = PLANT AND CHARG = P_CHARG.

" mention the table name in where condition also like a_{werks or b}werks.

egards

Rajendra

Re: select with inner join

Former Member — Tue, 17 Mar 2009 06:21:56 GMT

SELECT A~MATNR A~CHARG A~ERSDA B~MENGE B~MEINS
FROM MCHA AS A INNER JOIN CHVW AS B
ON A~CHARG = B~CHARG
INTO TABLE T_OUTPUT1
WHERE *A~*WERKS = PLANT AND *A~*CHARG = P_CHARG.

Try to use the above code.

regards,

~Satya

Re: select with inner join

Former Member — Tue, 17 Mar 2009 06:24:37 GMT

Hi Bupi Kaler,

You can use where condition.

Here problem is you could use A_{WERKS OR B}WERKS instead of WERKS and

A_{CHARG or B}CHARG instead of CHARG in where condition.

It will solve your problem.

Prasad GVK