update join view