update join queries spec