linq的join語法

https://blog.miniasp.com/post/2010/10/14/LINQ-to-SQL-Query-Tips-INNER-JOIN-and-LEFT-JOIN

from c in Categories
join o in Products on c.CategoryID equals o.CategoryID into ps
from o in ps.DefaultIfEmpty()
select new { c.CategoryName, o.ProductName }

left語法確保products資料完整出現

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////



select * from [dbo].[AFM_CheckList] c RIGHT join [dbo].[AFM_Product] p
on c.ProductID = p.ProductID