Self join in Entity Framework

Posted by Waheed on Stack Overflow See other posts from Stack Overflow or by Waheed
Published on 2010-05-22T10:49:44Z Indexed on 2010/05/22 11:00 UTC
Read the original article Hit count: 957

SELECT  c2.* 
FROM    Category c1 INNER JOIN Category c2
ON      c1.CategoryID = c2.ParentCategoryID
WHERE   c1.ParentCategoryID is NULL

© Stack Overflow or respective owner