with a little more trial and error:
My issue seems to result from using the "right-click-menu" to Add the Join
If instead, I use that "+" icon in the query to Add the Join, then it builds the join condition correctly
I could post pictures if more clarity is needed
... View more