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

1 vote180 views1 answer
What is intersect
SQL
3 votes200 views2 answers
Truncate table
SQL
1 vote190 views2 answers
Oracle replace
SQL
0 vote181 views1 answer
Postgresql stored procedure update table values
SQL
0 vote192 views1 answer
Sql find table by name
SQL
0 vote196 views1 answer
Exectuer myssql .sql
SQL
0 vote214 views1 answer
Mysql auto increment default value with prefix month and year
SQL
31 votes184 views3 answers
Sql count(*)
SQL
0 vote310 views1 answer
Mssql unique key accept nulls
SQL
0 vote185 views1 answer
Mssql now diff 90 day
SQL