The select statement on my post is complete - I just copied it from my post into SSMS, changed the offending join to a LEFT join as described in my original post, and it ran.

Are you referring to another statement? If you require more information, please let me know and I'll do my best to provide it.