出勤反转导致mysql

作者: 部落用户
发布时间: 2024-01-06 02:45:14 (4月前)
转自：

2 条回复

0#
回复此人
文艺青年 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 尝试此查询我通过student_class_tbl.student_REG_number ASC添加了订单 </p> <pre> <code> select student_class_tbl.student_REG_number, student_tbl.first_name as fn, student_tbl.lastname, accademic_year.year_name FROM student_class_tbl INNER JOIN classes_tbl on student_class_tbl.class_ID=classes_tbl.class_ID INNER JOIN student_tbl on student_class_tbl.student_REG_number=student_tbl.student_REG_number INNER JOIN accademic_year on student_class_tbl.accedemic_id=accademic_year.accademic_year_ID order by student_class_tbl.student_REG_number ASC </code> </pre> </DIV>

编辑

登录后才能参与评论