UPDATE CU0001 SET
LLICENCIA = (SELECT C10 FROM CU0001E WHERE C11 = CU0001.DNI),
NOM = (SELECT C5 FROM CU0001E WHERE C11 = CU0001.DNI),
COGNOM1 = (SELECT C6 FROM CU0001E WHERE C11 = CU0001.DNI),
COGNOM2 = (SELECT C7 FROM CU0001E WHERE C11 = CU0001.DNI),
CODIUCI = (SELECT C13 FROM CU0001E WHERE C11 = CU0001.DNI)
WHERE EXISTS (SELECT * FROM CU0001E WHERE C11 = CU0001.DNI)