sql - MySQL conditional subquery -

i trying run subquery based on condition:

select `table1`.`id`, (     select `table2`.`name`      `table2`      `table2`.`id` = `table1`.`table2_id` ) 

conditional on table2_id not being 0.

so if it's zero, table1.id gets selected, else table1.id , table2.name gets selectectected. assume i'll inner join tables later.

i tried both case then , if (), can't syntax work.

i'm using mysql 5.5

so sounds want left join table 2 ? means show table1.id, , if table 2 matches show otherwise null

select table1.id, table2.name table1 left join table2  on table1.table2_id = table2.id