select * from dbo.Table1 LEFT OUTER JOIN dbo.Table2 AS Table2 INNER JOIN dbo.Table3 AS Table3 ON Table3.Id = Table2.LnId ON Table2.Id = Table1.Column1
from Table1 in ctxk.Table1 join Table2 in ctx.Table2 on equals into ExternalPerson_join from Table2 in ExternalPerson_join.DefaultIfEmpty() join Table3 in ctxk.Table3 on new { aid = Table2.LnId, bid = Table2.Id } equals new { aid = Table3.Id, bid = Table1.LnId } select new { Table1, Table2, Table3 }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)