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

3 votes136 views1 answer
Postgres kill running query
SQL
1 vote141 views2 answers
Mysql extract month
SQL
0 vote146 views1 answer
Select place default lat long
SQL
2 votes142 views3 answers
Install mysql workbench ubuntu 20.04 terminal
SQL
0 vote144 views1 answer
Mysql DDL
SQL
0 vote168 views1 answer
Multiple like values for single column postgres
SQL
0 vote137 views1 answer
Oracle job class
SQL
0 vote158 views1 answer
Python connect to mysql in settings.py
SQL
6 votes180 views3 answers
Mysql change auto_increment start value
SQL
22 votes151 views3 answers
Remove all records from table mysql
SQL