For Example: Select BillMain.ID, BillMain.AccountID, BillMain.ItemID from BillMain Left Join BillSub ON BillMain.Ref = BillSub.Ref AND BillMain.Billing = BillSub.Billing
var result=from a in BillMain join b in BillSub on new{a.Ref,a.Billing} equals {b.Ref,b.Billing} into res from r in res.DefaultIfEmpty() select new {ID=a.ID,AccountID=a.AccountID,ItemID=a.ItemID};
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)