Select j.bm,j.gh,j.kuanh,j.xm,j.rq,j.wltm,j.gxmc,j.bzdj,j.je,j.zdh,j.zhah,j.shul,
z.bh,z.ddh, z.ddsl,
m.tmbh,m.zdkhi,m.color,m.csize,m.shul
From jjgzmxb j left join zhidanbase z on j.zdh =z.zdh
left join mes_zhidaninfo m on j.wltm =m.jwltm
join mes_zhidaninfo d on j.zdh=d.zdh
where j.zdh='11839-01f'