LINQ
Select operator
SelectMany operator
Union with SelectMany
Outer join with SelectMany
Inner join with SelectMany