Update query in SQL: command not ended properly

Guest User

4y892SQL

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’ );

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Uday Dodiya4y ago

Try To change like this because in your query you used ’ this is not valid so i just change it to ' so it's works fine

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');