topic Re: join in Application Development and Automation Discussions

join

Former Member — Sun, 04 Feb 2007 11:14:24 GMT

difference between inner join and outer join

Re: join

Former Member — Sun, 04 Feb 2007 11:17:33 GMT

Here it is

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21ec77446011d189700000e8322d00/content.htm

Regards

Kathirvel

Re: join

Former Member — Sun, 04 Feb 2007 13:05:02 GMT

good

http://help.sap.com/saphelp_nw04/helpdata/en/29/ca0b40c6c01961e10000000a155106/content.htm

THANKS

MRUTYUN^

Re: join

Former Member — Mon, 05 Feb 2007 05:21:12 GMT

Hi,

Inner join between table 1 and table 2 where column D sets the

join condition:

Table 1 Table 2

A B C D D E F G H

a1 b1 c1 1 1 e1 f1 g1 h1

a2 b2 c2 1 3 e2 f2 g2 h2

a3 b3 c3 2 4 e3 f3 g3 h3

a4 b4 c4 3

\ /

Inner Join

A B C D D E F G H

a1 b1 c1 1 1 e1 f1 g1 h1

a2 b2 c2 1 1 e1 f1 g1 h1

a4 b4 c4 3 3 e2 f2 g2 h2

Each comparison in the ON condition must contain a field

from the right-hand table.

Left outer join between table 1 and table 2 where column D sets

the join condition.

Tabelle 1 Tabelle 2

A B C D D E F G H

a1 b1 c1 1 1 e1 f1 g1 h1

a2 b2 c2 1 3 e2 f2 g2 h2

a3 b3 c3 2 4 e3 f3 g3 h3

a4 b4 c4 3

\ /

Left Outer Join

A B C D D E F G H

a1 b1 c1 1 1 e1 f1 g1 h1

a2 b2 c2 1 1 e1 f1 g1 h1

a3 b3 c3 2 NULL NULL NULL NULL NULL

a4 b4 c4 3 3 e2 f2 g2 h2

Comparisons in the WHERE condition may not contain fields

from the right-hand table

Hope this helps.

Reward if helpful.

Regards,

Sipra

Re: join

anversha_s — Mon, 05 Feb 2007 05:23:56 GMT

hi,

table emp

empno name

a sasi

b xxx

c yyy

table sal

empno salary

a 1000

b 2000

Inner join

****************

select e_{empno e}name

s~sal

into table int_table

from emp as e

inner join sal

e_{empno = s}empno.

if you made inner join between table a and b by emp no

the selection retrives only if the condition satisfy the output will be

a sasi 1000

b xxx 2000

Outer join

*************************

select e_{empno e}name

s~sal into table int_table

from emp as e

LEFT OUTER JOIN sal

e_{empno = s}empno.

if you made outer join (left /right ) the left table kept as it is the

if the condition satisfy the right table entries will fetch else leave it blank

the output will be

a sasi a 1000

b xxx b 2000

c yyy

Rgds

Anver