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 vote274 views1 answer
Access the postgres psql
SQL
0 vote273 views1 answer
How to output a different column name in mysql
SQL
13 votes299 views4 answers
Mysql remove foreign key constraint
SQL
1 vote345 views2 answers
Copy table in sql
SQL
7 votes270 views3 answers
Restore postgres database from sql file
SQL
0 vote268 views1 answer
Do postgresql
SQL
4 votes256 views2 answers
How to delete row in sql
SQL
1 vote253 views1 answer
Sql update table remove spaces
SQL
4 votes261 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote291 views2 answers
How to take recent row without limit in mysql
SQL