Good evening I have a table with primary key composed.
create data table
primary key (id)
drop table Status_Data;
create table Datos_estatus
Primary key (policy_id, status)
in table Datos_estatus
I need to change the state = 8 of all the IDs with the value = 1 in the table Datos_estatus
I tried to update and merge internally, but it does not work for me.