Update Fare_strategy Set Sales_date_to = ’07-sep-22’ Where Dep_date_to is Not Null and Market_id in (Select Market_id From Fare_strategy_markets Where Set_type = ‘standard’ );