change the join type