topic Re: Default join in select statements in Application Development and Automation Discussions

Default join in select statements

Former Member — Thu, 08 Mar 2007 05:13:27 GMT

Hi guyz,

If I am using just Join in my select statement. What does it do by default

1. innter join

2. outer join

eg:

select vbeln posnr into table itab from vbak <b>join</b> vbap on vbak_{vbeln = vbap}vbeln.

Thanks.

Re: Default join in select statements

Former Member — Thu, 08 Mar 2007 05:14:10 GMT

Hi,

By default it is INNER JOIN.

Regards,

Anji

Re: Default join in select statements

Former Member — Thu, 08 Mar 2007 05:15:14 GMT

Its inner join by default.

Re: Default join in select statements

Former Member — Thu, 08 Mar 2007 05:18:47 GMT

Mgs,

By Default innerjoin.

See the diff.

Hi karan check also the "left outer join" statement.

It might help you if you need 1-N relation

// left outer Join

Table 1 Table 2

|--|||--|

\ /

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 |

|--||||||||--|

// Inner Join

Table 1 Table 2

\ /

Inner Join

Pls. mark if useful

Re: Default join in select statements

Former Member — Thu, 08 Mar 2007 06:09:46 GMT

Hi mg s,

Actually the join statment is an SQL statement. There are two joins , Inner join and Outer join.

Inner join is the default join in the select statement. It can also be called as join by default.

Coming to outer join, It is used to map all the field of the first table with one field of second table.

Hope this helps you.

Reward all the useful answers.

Regards