Sticking with the Venn Diagrams, we can think about "Students" as one circle and "Payments" as another circle. A complex join (or outer join) will return the overlap between the two circles AND the ...

Know what an outer join is Distinguish an inner join from an outer join Identify different types of outer joins: left, right, and full Now imagine another scenario where the class is going on a field ...