Return the Set Intersection of Two Sequences
Use the Intersect operator to return the set intersection of two sequences.
This example uses Intersect to return a sequence of all countries/regions in which both
var infoQuery = (from cust in db.Customers select cust.Country) .Intersect (from emp in db.Employees select emp.Country) ;
Dim infoQuery = _ (From cust In db.Customers _ Select cust.Country) _ .Intersect _ (From emp In db.Employees _ Select emp.Country)
In LINQ to SQL, the Intersect operation is well defined only on sets. The semantics for multisets is undefined.