I have let’s say 20 tables, which have chain_id column with values.
We have decided to change all chain_id values to new ones (it’s not PK/FK). I have a mapping table with chain_id and new_chain_id.

I have let’s say 20 tables, which have chain_id column with values.
We have decided to change all chain_id values to new ones (it’s not PK/FK). I have a mapping table with chain_id and new_chain_id.

I have let’s say 20 tables, which have chain_id column with values.
We have decided to change all chain_id values to new ones (it’s not PK/FK). I have a mapping table with chain_id and new_chain_id.

I have let’s say 20 tables, which have chain_id column with values.
We have decided to change all chain_id values to new ones (it’s not PK/FK). I have a mapping table with chain_id and new_chain_id.

I need a sql query that updates new guid where it is null. But the update should happen based on another non-unique column.

I need a sql query that updates new guid where it is null. But the update should happen based on another non-unique column.