generate join entry