Computed columns acting weird

A fun little problem having to do with calculated columns in a join.