join ticket data