topic PROBLEM IN INNER JOIN in Application Development and Automation Discussions

PROBLEM IN INNER JOIN

laxman_sankhla3 — Fri, 24 Aug 2007 05:58:37 GMT

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.

Re: PROBLEM IN INNER JOIN

seshatalpasai_madala — Fri, 24 Aug 2007 06:00:01 GMT

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

Re: PROBLEM IN INNER JOIN

Former Member — Fri, 24 Aug 2007 06:00:11 GMT

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.

Re: PROBLEM IN INNER JOIN

Former Member — Fri, 24 Aug 2007 06:02:55 GMT

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.

Re: PROBLEM IN INNER JOIN

Former Member — Fri, 24 Aug 2007 06:04:54 GMT

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

Re: PROBLEM IN INNER JOIN

Former Member — Fri, 24 Aug 2007 06:04:57 GMT

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