New answers tagged


output alone is not going to work (easily) as you have two things going on insert into student (name) select distinct studentName from table; insert into teacher (name) select distinct teacherName from table; insert into studentTeacher(studentID, teacherID) select student.ID, teacher.ID from table join student on = ...

Top 50 recent answers are included