mysql怎么根据一个表查询到的值作为条件查询另一个表的值

假设你成绩表名是user，成绩表名师mark，两表用uid做关联： select U.uid, U.name,M.score from user as U inner join (select uid, score from Mark order by score desc limit 15) as M on U.uid = M.uid；