what is difference between inner join and outer join ?

[Former Member]

Hi SAP-ABAP Experts .

With Due Regards .

May u explain me what is difference between inner join and outer join ?

(Left inner/Left join )

Please explain with example .

Which is better performance wise ?

Joins is better or For all entries is better ?

Best Regards to all : Rajneesh

[Former Member]

Check out the below threads

http://help.sap.com/saphelp_nw04/helpdata/en/67/7e4b3eaf72561ee10000000a114084/content.htm

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

[Former Member]

Basically Select statement with JOIN option will be written when there exists a common field between the two tables. And in order to join two records from the two tables the common field must have same value in those two tables.

INNER JOIN : When Select statement is written using this option, records will be fetched only if the common field have same value and a join is possible.

OUTER JOIN : When the common field do not have same value and even u want such records to be selected where join is not happening then this option have to be used.

For all entries are having better performance

hope this is helpful info.

[Former Member]

Hi,

The data that can be selected with a view depends primarily on whether the view implements an inner join or an outer join.

Inner join is like intersecion ....in which data will be fetched from 2 tables comparing a field wich is common in both the table n those data will be fetched where the field value matches..

With an outer join, records are also selected for which there is no entry in some of the tables used in the view.

Check these to know the difference..

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

https://forums.sdn.sap.com/click.jspa?searchID=11269846&messageID=4933923

Regards

Kiran Sure

[Former Member]

Inner join : An inner join (sometimes called a "simple join") is a

join of two or more tables that returns only those rows that satisfy the join condition.

Outer Join : An outer join extends the result of a simple join. An outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition

[Former Member]

Hi Rajnish

Joins are used to have the matching records of tables, for this we use inner joins, whereas in outerjoins, we've leftouter and rightouter joins. Leftouter : here all records of leftmost table will display by placing blanks or zeroes for rightsided table.

Rightouter : here all records from rightmost table will display

These joins are only for tables of relation 1 to n. But to support for n to n, n to 1 tables we've to go for FOR ALL ENTRIES.

In performance view, it is preferred over joins.

For further doubts, feel free to contact me.

If it founds helpful, reward me plz.

Thanks

Suren