可以用简单的等值连接来查询解决此题的多表情况
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 = '浙江大学'
可以用简单的等值连接来查询解决此题的多表情况
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 = '浙江大学'