select with inner join

[Former Member]

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.

[Former Member]

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

[Former Member]

Yes you can use it.

In the above where clause give

A-WERKS OR B-WERKS and

A-CHARG OR B-CHARG.

Cheers,

Surinder

[Former Member]

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

[Former Member]

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

[Former Member]

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.

by

Prasad GVK