查询用户已经测试过的某套试题的相关信息:
SELECT
t0.test_line_id ,t0.score ,
t0.sort_index,
t0.type,
t1.anwser ,
t1.myanwser
FROM
e_test_line t0 LEFT JOIN
(SELECT * FROM e_test_result_line t2 WHERE t2.test_result_head_id= ?) t1 ON t0.test_line_id=t1.test_line_id
WHERE
t0.test_head_id= ?
ORDER BY
t0.sort_index