The join for the relationship as a spelled-out string (e.g. "inner join").