更新一張與另一張表關聯的連線欄位記錄

UPDATE enrollments e
JOIN students s ON e.student_id = s.student_id
SET e.email = s.email;