What is the difference between Inner joins and Outer joins?

Interview Candidate
May 23rd, 2006
1
1733

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

Ben Orlowitz

Aug 14th, 2006

Inner joins return rows from both joined tables where the join keys are equal. Outer joins return all rows from the "outer" table (which can be on the right or left side of the join) and only those rows from the other join table where the keys are equal.