How to pull additional course and student id information from one table and put into another?

Question

SQL

I have a database which has a PurchaseList table. It contains the following fields: student_name,
course_name, price, subscriptionDate. The task is to use the table PurcahseList to pull out additional. information (ID of the course and student) and add everything to another table with the fields: student_id and course_id.
How can I do that?

Answer 1

Well, something like this, depending on what database.
INSERT INTO other_table (student_id, course_id)
VALUES (SELECT course_id, student_id FROM PurchaseList)