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

5 votes332 views1 answer
Oracle ora-00054 causes
SQL
10 votes353 views3 answers
Sql check double value
SQL
-2 votes363 views1 answer
Trunc in sql
SQL
16 votes430 views2 answers
Sql vs nosql
SQL
5 votes383 views1 answer
Oracle nls session
SQL
7 votes361 views3 answers
How ot change name of column mysql
SQL
0 vote394 views1 answer
Dynamic where clause in sql server stored procedure
SQL
12 votes340 views4 answers
Install mysql ubuntu 18.04
SQL
0 vote359 views1 answer
Mysql select smaller of two values
SQL
1 vote366 views2 answers
Get table column names sql laravel
SQL