1. I want to find out the student's student ID, class, name, course selection question, and instructor. The structure of the four tables is as follows: 1. 1. student Information Table (tstudentInfo): ID, class, name2. instructor Information Table (tteacherInfo): ID, name3. topic table (tproject): teacherID, projectID, projectName4 course selection Information Table (tchoiceInfo): studentID, firWish, secWish, firState, secTate each student in the course selection Information Table (tchoiceInfo) all... the query statement is complex. mysqlsql does not ask for help.
- I want to find out the student's student ID, class, name, course selection question, instructor. The structure of the four tables is as follows:
- 1. student Information Table (tstudentInfo): ID, class, name2. instructor Information Table (tteacherInfo): ID, name3. topic table (tproject): teacherID, projectID, projectName4 course selection Information Table (tchoiceInfo): studentID, firWish, secWish, firState, secTate each student has a record in the course selection Information Table (tchoiceInfo). each student has two volunteers and only one student will be selected, in secWish, the student's selected subject ID is entered. the selected volunteer status is set to 1.