Refactored join transaction to be more explicit on join failures updated tests