Outer Joins
Wednesday, February 23, 2011
2:39 PM
An inner join omits records for which there is no match. 
There are three other kinds of (binary) joins: 
LEFT OUTER: left record included even if no match. 
RIGHT OUTER: right record included even if no match. 
FULL OUTER: both sides: record included even if no match