topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Fri, 21 Sep 2007 06:08:46 GMT

Hi,

While making inner join b/w 2 tables should we match all the common fileds in both the tables even if they r not key fields in the tables?

Regards,

Hema

Re: inner join

JozsefSzikszai — Fri, 21 Sep 2007 06:12:15 GMT

hi Hema,

it is enough if you match the key fields at least of one table. For example between MARA (material and MAKT you have to match only MATNR.

You can give your own examples here, than I can help more.

hope this helps

Re: inner join

Former Member — Fri, 21 Sep 2007 06:14:38 GMT

Hi,

No it is not necessary to match all the common fields, You match the fields according to your requirement. more fields you match more data will get filtered.

Re: inner join

Former Member — Fri, 21 Sep 2007 06:32:04 GMT

Hi, You can do the inner join b/w two tables with using a single field also.

like ,

<b> select select a~vbeln

a~bstnk

a~kunnr

b~posnr

b~matnr

b~netwr

into table i_basic

from vbak as a Inner join vbap as b

on a_{vbeln eq b}vbeln.</b>

Re: inner join

Former Member — Fri, 21 Sep 2007 06:38:28 GMT

If there is not direct relation between two tables, search for a relation through a 3rd table and join all three..

reward if solved**

Re: inner join

Former Member — Fri, 21 Sep 2007 07:22:27 GMT

Its not necessary that u have to link all the common fields in the table.Just need one joining condition.In joins we can join more than 2 tables.

Regards

Shibin