# 方法一 # select device_id, question_id, result # from question_practice_detail # where device_id in ( # select device_id # from user_profile # where university = '浙江大学' # ) # order by question_id; # 方法二 # select u.device_id, q.question_id, q.result # from question_practice_detail as q, user_profile as u # where # university = '浙江大学' and q.device_id = u.device_id # order by # q.question_id ASC; # 方法三 # select u.device_id, q.question_id, q.result # from question_practice_detail q join user_profile u on q.device_id = u.device_id and u.university = '浙江大学' # order by q.question_id ASC; # 方法四 # select u.device_id, q.question_id, q.result # from question_practice_detail q join user_profile u on q.device_id = u.device_id # where u.university = '浙江大学' # order by q.question_id ASC;