I can't seem to wrap my brain around what strikes me as very simple.
Assume I have these two simple tables (IEnumerables really)
Table1: Authorities (IEnumerable<AuthorityRow>)
Table2: MatchList (IEnumerable<MatchListRow>)
How can I produce a list of Positions who have all the Authorities listed in MatchList?
In the example above, CFO and CEO should be produced, but not HR Leader.
I normally prefer the method-based syntax but I'm not too particular and would be just as pleased with query-based.