内连接查询: select q.device_id,q.question_id,q.result from question_practice_detail q inner join user_profile u on q.device_id=u.device_id where university in('浙江大学');