JR1000 added the join with designation view