join and updates