• bvrolyk (7/17/2013)


    This is my issue as well. I need Father3 displayed in the final result set.

    In my "real world problem" I need to list the fathers with no children, not the children with no fathers.

    You might try

    Inner Join IsNull(c.parentId, p.ParentId) = p.ParentId with a null value in the child table. I've tried it, and it's very slow as a select, making me reluctant to do it for the index view--and since I actually need two left joins...I should probably go ahead and see what it does to my inserts, but at the moment I'm afraid the index will drag that down to an unacceptable level.