《班级管理系统》sql语句

select a._id,a.content,a.stu_id,a.addDate,b.nam from `note` as a inner join `stu_info` as b on a.stu_id = b.idx order by a.addDate desc limit 10