UPDATE t1
INNER JOIN `t2` ON (`t1`.`nip` = `t2`.`nip`)
SET
t1.id_jenis_jabatan = t2.`id_jenis_jabatan`
WHERE
`t1`.`id_jenis_jabatan` LIKE `t2`.`id_jenis_jabatan`
UPDATE t1
INNER JOIN `t2` ON (`t1`.`nip` = `t2`.`nip`)
SET
t1.id_jenis_jabatan = t2.`id_jenis_jabatan`
WHERE
`t1`.`id_jenis_jabatan` LIKE `t2`.`id_jenis_jabatan`