revise join.pl