Linq2Sql How to write outer join query?
- by Malcolm
Hi,
I have following SQL tables.
ImportantMessages
impID
Message
ImportantMessageUsers
imuID
imuUserID
imuImpID
I want to write a Linq2Sql query so that it returns any rows from ImportantMessages
that does not have a record in ImportantMessagesUsers.
Matchiing fields are
impID ----- imuImpID
Assume imuUserID of 6