Outer Join and Inner Join in SQL

ginny

Member
Hello,
Can anyone explain to me the difference between the outerjoin and innerjoin in SQL statements.I get confused about it all the time.
Thank you,
Ginny
 
Inner Join

An inner join, also called a direct join, combines data from tables that have a column of information in common.

Left Outer Join

A left outer join returns data that two tables have in common and also includes data from the primary, or first table selected, which does not have matching data to join to in the secondary table.

Exception Join

An exception join returns only the data from the primary, or first table selected, which does not have matching data to join to in the secondary table.

Cross Join

A cross join matches every row of the primary table with every row of the secondary table. This type of join results in a Cartesian product of the tables and is generally detrimental to performance and not desired.
 
Back
Top