inner join时的问题

Question

TRY:
select table1.id,table1.column1,table1.column2,table2.column1 from table1 left join table2 on table1.column2 = table2.id

Answer 1

thx
诶，真后悔在学校没好好学啊，都忘光了。揭帖！
to yoki(小马哥)：CrazyFor(蚂蚁)说的不错

Answer 2

select table1.id, table1.column1, table1.column2, table2.column1 
 from table1 left join table2 
   on table1.column2 = table2.id