可是另一個常用的LEFT JOIN要怎麼辦呢?
特地找了一下
from A in A_tab
join B in B_tab on A.code equals B.code into ps
from B in ps.DefaultIfEmpty()
select new { A.Name, B.item_Name }
他所產生的SQL同等於
SELECT [A_tab].[Name], [B_tab].[item_Name]
FROM [A_tab] AS [A]
LEFT OUTER JOIN [B_tab] AS [B] ON [A].[code] = [B].[code]
在此紀錄
