update join type