title: How to write LINQ Join command in lambda expression
body: <p>I have written the following JOIN statement in LINQ:</p>
  
  <pre><code>var result = (from od in orders
  join em in employees on od.EmployeeID equals em.EmployeeID
  join ct in customers on od.CustomerID equals ct.CustomerID
  
  select new MyJoin
  {
      OrderID = od.OrderID,
      //OrderDate = od.OrderDate,
      ShipCountry = od.ShipCountry,
      CompanyName = ct.CompanyName,
      ContactName = ct.ContactName,
      EmployeeName = (em.FirstName + ' '+em.LastName),
  })
  </code></pre>
  
  <p>How would I write this as a lambda expression?</p>