In Plan Explorer I see that the Join Diagram is missing some connections
Just an FYI – In my SQL, I'm using a CTE followed by a SELECT. The table that is displayed as not connected in the JOIN diagram is the table in the FROM within the CTE. I believe my version is current.
If this post contains any of my actual code, please remove the code from the post.