Joining by strings can make sense if there is a natural key. Often, for performance, you would use a surrogate key even if a natural key exists but there are rare times it makes sense.