select up.device_id,qpd.question_id,qpd.result from question_practice_detail qpd INNER JOIN user_profile up where up.university='浙江大学' and qpd.device_id=up.device_id order by question_id INNER JOIN user_profile up:两个表操作,所以需要连接操作 where up.university='浙江大学' and q...