Hi, first of all excuse me for my poor English.

I've a table:

CHANGE_NAME | ID | NAME
---------------------------
(empty) | 1 | Kowalski
---------------------------
(empty) | 2 | Nowak
---------------------------
Dubiel | 3 | Szaton
---------------------------
Oles | 4 | Zyłka
---------------------------
(emty) | 4 | Zyłka


but i need something like this - if in field CHANGE_NAME is empty the field NAME is no changing, but if the somebody writed something in this field the field in column NAME is also changed
but not only in one row but in all row's that has the same ID field. So in this case the table must look like this:


ID | NAME
---------------
1 | Kowalski
---------------
2 | Nowak
---------------
3 | Dubiel
---------------
4 | Oles
---------------
4 | Oles

Can somebody help me?