还有一个教师表,里面的有TID(教师编号),TName(教师姓名),
Major表里面的Counselors是参照的教师表里面的TID(教师编号)。
帮忙根据上面这三表表把以下两条SQL语句合并成一条,谢谢了。
insert into Major(Major,MajorID) values ('" + textBox1.Text + "','" + textBox2.Text + "','"+ textBox3.Text + "')
insert into Major(Counselors,PID,DepID)select Counselors,PID,DepID from Teacher,Department where Teacher.TName = '"+ textBox3.Text + "'and Department.DepName = '" + comboBox1.Text + "'"
当然合并这两条语句时请各位还是先看下我这两条语句错了没有。先在这里谢谢各位了