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 votes150 views1 answer
How to delete all duplicate items in mysql
SQL
0 vote133 views2 answers
SQL Server Standard
SQL
0 vote154 views1 answer
Microsoft sql server python connection
SQL
0 vote144 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
3 votes159 views2 answers
Enter mysql command line
SQL
1 vote171 views1 answer
Is sql fast
SQL
0 vote238 views1 answer
Mysql edit trigger
SQL
0 vote128 views2 answers
How do I install microsoft SQL on my Mac?
SQL
1 vote137 views1 answer
Mysql select row with max value group by
SQL
21 votes146 views4 answers
Oracle add column
SQL