ALTER TABLE REGISTRATION ADD COLUMN INGRESSION VARCHAR(100);
ALTER TABLE REGISTRATION ADD COLUMN ENTRY_PHASE INT(11);

UPDATE REGISTRATION INNER JOIN CANDIDACY ON CANDIDACY.KEY_REGISTRATION = REGISTRATION.ID_INTERNAL 
SET REGISTRATION.INGRESSION = CANDIDACY.INGRESSION, REGISTRATION.ENTRY_PHASE = CANDIDACY.ENTRY_PHASE;