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

23 votes126 views6 answers
Delete all rows from table sql
SQL
0 vote129 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
1 vote124 views1 answer
Sql where last 12 months
SQL
0 vote131 views1 answer
Psql store procedure-return multiple table values
SQL
3 votes132 views5 answers
No module named 'MySQLdb'
SQL
0 vote138 views1 answer
Hoq to import database source
SQL
0 vote131 views1 answer
Mysql select row with min date
SQL
0 vote123 views1 answer
See the structure of a table mysql
SQL
0 vote137 views1 answer
How to select even id in sql
SQL
0 vote127 views1 answer
Sql string contains case sensitive
SQL