MYSQL - Insert Select Statement

i use this statement when i want to copy data in selected fields in a table.

INSERT INTO student_subject (subjectid, noofsem)
SELECT subjectid, noofsem FROM study_plan
WHERE student_subject.intakeid = study_plan.intakeid