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 vote322 views1 answer
Oracle lock user
SQL
8 votes365 views2 answers
How to fetch data from database without last column
SQL
0 vote340 views1 answer
Reona
SQL
0 vote320 views2 answers
Mysql to python pandas
SQL
0 vote333 views1 answer
Sql count total by foreign key
SQL
0 vote358 views1 answer
Oracle grant create job
SQL
0 vote378 views1 answer
Python mysql check if database exists
SQL
5 votes333 views4 answers
Mysql on duplicate key update
SQL
0 vote323 views1 answer
Grepper sql workbench download
SQL
0 vote397 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL