Joining two sets with LINQ
Dealing with a horrible database this last week, I found the need to