The query returns the same results regardless of whether ANSI_NULLS is on or off.

Thanks,

Reid

Your query gave me the same results.

One other interesting thing that I didn't mention before is that changing the "L.BdKey Is Null" to "IsNull(L.BdKey,-1) = -1" actually gives me...

I'm not sure what "Learn you JOINs" means, but I do prefer the changes you made to the join. That being said, the results should come out the same.

This...