inner join and outer join

[Former Member]

hi,

what is the diff b/w inner join and outer join?

thanks regards,

kiran.

[Former Member]

hi Kiran,

Check these to know the difference..

http://help.sap.com/saphelp_erp2005/helpdata/en/cf/21ec77446011d189700000e8322d00/frameset.htm

Regards,

Santosh

Note: Reward Points if helpful

[RichHeilman]

<i>

In an inner join, a line from the left-hand database table or join is only included in the selection if there is one or more lines in the right-hand database table that meet the ON condition <cond>. The left outer join, on the other hand, reads lines from the left-hand database table or join even if there is no corresponding line in the right-hand table.

</i>

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb39c4358411d1829f0000e829fbfe/frameset.htm

Regards,

Rich Heilman

[former_member181962]

There is nothing called outer join.

There wil be only inner join which means you are slecting entries from both tables only if it meets the codition that the secong table's field matches with the first table's field.

REgards,

Ravi

[RichHeilman]

Ravi, there is an "outer join".

Read the links provided.

Regards,

Rich Heilman

[Former Member]

Note that Dr. Codd (the father of the Relational Database) created inner and outer joins based on the mathematical concepts of Unions and Intersections.