可以用in以及嵌套查询,如:
update t set amount=10 where 销售季名称="过季" and store_code in (exec store_code from (select count(新品预算) as cnt from t group by store_code) where cnt=0)
或者分步查询,如:
code=select store_code from t group by store_code having count(新品预算)=0
update t set amount=10 where 销售季名称="过季" and store_code in code[`store_code]