Subquery specification update