Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jean Charles Bulinckx Indexed Views With Outer Joins RE: Indexed Views With Outer Joins
Pridmore_James
Mr or Mrs. 500
Points: 540
More actions
April 23, 2013 at 5:03 am
#1608999
Your example doesn't work.
In the left and right joins, Father 3 is displayed.
With the isnull(....), there is no child record in the son table to apply the isnull too, therefore, the father record never appears.