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

2 votes170 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote162 views1 answer
Oracle c# multiple update sql
SQL
12 votes171 views4 answers
Psql command not found
SQL
0 vote173 views1 answer
Sql injection payload list github
SQL
0 vote169 views1 answer
Createdb with postgresql on ubuntu
SQL
12 votes147 views4 answers
Mysql get date difference in hours
SQL
0 vote173 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote304 views2 answers
Create new table from existing table with data in sql server
SQL
1 vote322 views1 answer
Postgres convert text to number
SQL
0 vote258 views1 answer
Drop check command
SQL