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 vote355 views1 answer
Plsql check for string in numeric
SQL
1 vote344 views1 answer
Sql auto date
SQL
1 vote365 views1 answer
Access the postgres psql
SQL
0 vote364 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote377 views4 answers
User defined function sql
SQL
13 votes361 views2 answers
Get tables in database sql
SQL
0 vote349 views1 answer
Codeigniter dbforge add index
SQL
15 votes639 views2 answers
How to sort names in alphabetical order in sql
SQL
4 votes427 views2 answers
Sql display today's date
SQL
1 vote368 views1 answer
Mariadb alter user host
SQL