1var result = from ord in db.Orders
2 join osub in (from o in db.Orders
3 where o.region = "Canada"
4 select o)
5 on ord.orderId equals osub.orderId
6 select new {ord.custId, ord.orderDate};