Join and fetch implementation