这不需要子查询吧?联合查询就实现了啊
select id, state,type,quiz_id a2.name form a1 left join a2 where a1.quiz_id=a2.id state='1'
select id, state,type,quiz_id a2.name form a1 left join a2 where a1.quiz_id=a2.id state='1'
调试欢乐多
select a1.id, a1.state,a1.type,a1.quiz_id,a2.name from a1 , a2 where a1.state="1" and a1.quiz_id = a2.id