主从表外联结查询

查询用户已经测试过的某套试题的相关信息：
www.2cto.com

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