Table class column class_name class_code
The teacher column teacher_name teacher_code
Less than the teacher and the class data data
Specific display effect as shown in figure, just contact my SQL programmer

CodePudding user response:

Since there is no worry, why must query processing together? Two queries, finally each fill in the form, of course you have to query is not can't together, just more trouble, it is better to split into two