ALLNOBLANK confusion - please help

[music43]

Hi

Have I completely missed the point of this function or is there something going on here that I just don't grasp? 

Thanks in advance.

Oli

[music43]

Thank you for the clarification! 

I hope you have a good day.

[johnt75 · Accepted solution]

It is confusing. ALLNOBLANKROW only filters out blank values if they have been automatically added to create a valid relationship. If the blank values exist in the underlying data then they will still be returned. 

To make sure that blank values are not returned use DISTINCT instead.