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

2 votes244 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
-1 vote237 views1 answer
Mysql #1064 error
SQL
0 vote263 views2 answers
Get item by composite primary key mysql
SQL
0 vote242 views1 answer
Sql query to find duplicate email address
SQL
0 vote220 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
1 vote234 views1 answer
Install postgresql on raspberry pi
SQL
0 vote234 views1 answer
Datagrip go to line
SQL
0 vote239 views1 answer
Mysql where in keep order
SQL
2 votes258 views1 answer
Drop all foreign key constraints mysql
SQL
0 vote241 views1 answer
Addition of 2 column value in mysql
SQL