-- UPDATE with table alias in SET/WHERE
UPDATE core.reg_subject t SET t.code = 'X' WHERE t.id_subject = 1;
