Four tables a student table a curriculum course level table an intermediate table (intermediate table contains fields for the id student id level of course id id status)
Need to query the student's course and level of information

CodePudding user response:

This problem did not reply, you are advised to take 10 minutes time, learn the LEFT JOIN, JOIN, RIGHT to JOIN, very simple,