How to write this query in Linq2Sql
Posted
by RememberME
on Stack Overflow
See other posts from Stack Overflow
or by RememberME
Published on 2010-05-10T19:52:40Z
Indexed on
2010/05/10
20:24 UTC
Read the original article
Hit count: 243
I have a table company which holds the company_id, company_name and other details. I have a table subcontracts which has a company_id column that maps to company.company_id.
How can I write a select statement to get all companies which have not been assigned to a subcontract? IE The company_id cannot be found in subcontracts.company_id
© Stack Overflow or respective owner