What is the difference between "INNER JOIN" and "OUTER JOIN"?

asked17 years ago
last updated3 years ago
viewed2.6m times
Up Vote5.2kDown Vote

Also, how do LEFT OUTER JOIN, RIGHT OUTER JOIN, and FULL OUTER JOIN fit in?