可以用简单的等值连接来查询解决此题的多表情况

    SELECT
    	q.device_id,question_id,result
	from  
    	question_practice_detail as q,user_profile as u
    WHERE 
    	q.device_id = u.device_id and university = '浙江大学'