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 vote166 views1 answer
Create synonym for dblink in oracle
SQL
1 vote169 views1 answer
Postgresql define pk sequence next number
SQL
0 vote159 views1 answer
Csv to sqlite python
SQL
0 vote219 views1 answer
Get initials name in sql
SQL
5 votes184 views1 answer
Mysql count newlines in field
SQL
0 vote181 views1 answer
Extract sql from query object sqlalchemy
SQL
1 vote300 views1 answer
Postgres set column based on another column
SQL
1 vote181 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote133 views1 answer
Sql select rows with simlar names
SQL
1 vote171 views1 answer
Mysql show current queries
SQL