56,687
社区成员
发帖
与我相关
我的任务
分享
select u.*
from user u left join (select uid,score from score where 学期=所选的那个学期) b
on u.uid=b.uid
order by b.score
select t1.*,ifnull(t2.成绩,0) as new_values from `user` t1 left join score t2 on t1.学生ID=t2.学生ID
where 学期字段='学期值'
order by new_values desc