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

0 vote334 views1 answer
T sql dynamic top n query
SQL
0 vote348 views1 answer
Check database restore status sql script
SQL
0 vote344 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote266 views1 answer
Import csv to mysql
SQL
13 votes339 views3 answers
Insert mysql ifile nto database
SQL
8 votes353 views1 answer
See all users mysql
SQL
1 vote369 views1 answer
Sql random sampling per group
SQL
7 votes359 views2 answers
How to create index mysql
SQL
1 vote302 views2 answers
Postgresql backup and restore globals and data
SQL
103 votes529 views1 answer
Like sql
SQL