求大神用一条sql语句写出来，急，急，急。谢谢了mysql

Question

Answer 1

select b.*, a.billtype from table2 b left join table1 a on b.table_id=a.id