This email was created by [MemberName] <[MemberEmail]> who thought you would be interested in the following Article:
"Using GetAncestor() in a join"
GetAncestor() requires a slightly unusual outlook to get the required results
CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!