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 vote367 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
1 vote346 views1 answer
Oracle create as select
SQL
1 vote340 views1 answer
PLS-00225 type
SQL
5 votes338 views1 answer
Ascending order and where in sql
SQL
0 vote366 views1 answer
Oracle 11g forget password
SQL
4 votes344 views3 answers
NOT NULL SQL
SQL
1 vote354 views1 answer
Error code 1292 mysql workbench
SQL
3 votes446 views1 answer
Oracle nextval insert
SQL
2 votes295 views1 answer
Sql view column data type
SQL
3 votes337 views2 answers
Oracle synonym
SQL