LINQ
Join operator
GroupJoin operator
Outer join with GroupJoin