SQL update from modifies the value of one table from another table

Suppose there is table name Icate_table_set (table_id,table_name,table_state_id,store_id), table name Icate_table_state (state_id,state_ Name,state_attr status attributes such as empty tables, using Medium, store_id)

Store_id assume that the state name of each branch of the store ID may be different but the property is the same

Now we have to change all tables to correspond as empty table status (1 empty table)

UPDATE Icate_table_set

SET table_state_id= (SELECT state_id from Icate_table_state WHERE state_attr= ' 1 ' and store_id=a.store_id)

From Icate_table_set A,icate_table_state b

SQL update from modifies the value of one table from another table