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 vote219 views1 answer
Postgres populate table from another table
SQL
1 vote201 views2 answers
String to date postgres
SQL
1 vote202 views1 answer
Return size of tables in mysql
SQL
1 vote245 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
1 vote221 views1 answer
Sql select max value from multiple rows
SQL
1 vote205 views1 answer
Pgsql sum switch case
SQL
0 vote192 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
6 votes251 views2 answers
Oracle compile trigger
SQL
0 vote219 views1 answer
Limit in access query
SQL
-1 vote215 views8 answers
Create Trigger in phpMyAdmin
SQL