join refinement and view