Explanation
Target 1: from
Target 2: join
Target 3: on
Target 4: equals
Example: Join operations create associations between sequences that are not explicitly modeled in the data sources. For example you can perform a join to find all the customers and distributors who have the same location. In LINQ the join clause always works against object collections instead of database tables directly.
C#
var innerJoinQuery =
from cust in customers
join dist in distributors on cust.City equals dist.City
select new { CustomerName = cust.Name, DistributorName = dist.Name };
Reference: https://msdn.microsoft.com/en-us/library/bb397927.aspx
https://msdn.microsoft.com/en-us/library/bb397927.aspx