UPDATE CLIENTS A SET A.CLIENT_DESC = (SELECT B.CLIENT_NAME FROM CLIENTS B WHERE B.CLIENT_ID = A.CLIENT_ID)