Mysteriously Missing Rows with SQL Right Join
So I ran into an interesting problem at work today. One of our reports wasn’t showing all of the required locations. One instance turned out to be an error with another one of our systems. The rest led me down a 3 hour rabbit hole.