PROBLEM IN INNER JOIN

[laxman_sankhla3]

HI

can i use directly where condition with out using ON in query.

SELECT A_{VBELN A}AUDAT B_{KWMENG B}ARKTX B_{WERKS B}POSNR

INTO CORRESPONDING FIELDS OF TABLE INT_VBAK

FROM VBAK AS A INNER JOIN VBAP AS B

WHERE B~VSTEL IN S_VSTEL.

thanks.

[seshatalpasai_madala]

Hi,

<b>NO</b>, you cannot, you need to define ON which fields you want to do the JOIN, else ON WHAT CONDTION do you expect the tables to be joined.

This is to make sure that the tables you are joining are related in some way, otherwise there is no meaning in JOINING tables which are noway related to each other.

Regards,

Sesh

[Former Member]

SELECT A_{VBELN A}AUDAT B_{KWMENG B}ARKTX B_{WERKS B}POSNR

INTO CORRESPONDING FIELDS OF TABLE INT_VBAK

FROM VBAK AS A INNER JOIN VBAP AS B

<b>on A_{VBELN = B}VBELN</b>

WHERE B~VSTEL IN S_VSTEL.

[Former Member]

Hi,

No you have to specify the On condition, it will be the key to join both the tables.

use the vbeln ( document number ) to join both the table.

SELECT A_{VBELN A}AUDAT B_{KWMENG B}ARKTX B_{WERKS B}POSNR

INTO CORRESPONDING FIELDS OF TABLE INT_VBAK

FROM VBAK AS A INNER JOIN VBAP AS B

ON A_{VBELN = B}VBELN.

WHERE B~VSTEL IN S_VSTEL.

Satya.

[Former Member]

never..

there should be atleast one common field so that u can join two table.

And u have to write that in ON statement.

reward if helpful

[Former Member]

at least write 1 where statement on which the two table will be joined.the tables both will contain the same field.....after words u can use ur where IN statement

Regards