fix join's type