Sub query in linq

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

Similar codes

26 votes270 views10 answers
Insert in to table sql
SQL
0 vote336 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote313 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
0 vote330 views1 answer
Sql convert float to string
SQL
1 vote332 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote330 views1 answer
Two inner joins sql
SQL
1 vote365 views1 answer
Postgres see sequence current state
SQL
0 vote324 views1 answer
Mysql select all table that have field names
SQL
0 vote352 views3 answers
CONTACT FORM SQL
SQL
0 vote335 views1 answer
How to get specific salary in sql
SQL