mysql 一行转两行的问题 求救

Question

怎么实现sql 从左边的表查出 成为 右边的数据

Answer 1

 select * from ((select id, question as content from table1) union (select id, answer as content from table2) ) orderby id