左连接查询

 select a.* b.* from

(select * ftom table1 where table1.id='123434') a

left outer join table2 b on a.id=b.id