Alex Rivera | Logout

What is the difference between INNER JOIN and OUTER JOIN?

Asked 2008-09-01T22:36:06.940
5294

What is the difference between INNER JOIN and OUTER JOIN?

How do LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN fit in?

sql join inner-join outer-join
Edit
Report

1 Answer

128

A inner join only shows rows if there is a matching record on the other (right) side of the join.

A (left) outer join shows rows for each record on the left hand side, even if there are no matching rows on the other (right) side of the join. If there is no matching row, the columns for the other (right) side would show NULLs.

answered 2008-09-01T22:38:43.643

Your Answer