Nice! It seems like a strange request but I get it often. The boss generally wants a few exact match clauses and a subset of several "fuzzy match" clauses to determine what gets combined when I import awful duplicate customer data.

Last week I had a tougher scenario of joining about an average of a dozen rows into one (from thousands) where they matched each other on various subsets of many clauses.