[¤v¸Ñ¨M] ¥Ñ¤T­Ó¸ê®Æªí¥X¸ê®ÆSQL»yªk

sammyc

·s¤â¤@¦W
·Q¥Ñ¤T­Ó¿ï¨ú¸ê®Æ¦¨¤@table
        Table jjgzmxb
        select bm,gh,kuanh,xm,rq,wltm,gxmc,bzdj,je,zdh,zhah,shul from jjgzmxb where zdh=¡¨11839-01f¡¨
        table zhidanbase ¥Ñjjgzmxb -> zdh±a¥X bh,ddh ddsl
        Table zhidaninfo ¥Ñ jjgzmxb->wltm ±a¥X tmbh,zdkhi,color,csize,shul
        µ²ªG
        bm,gh,kuanh,xm,rq,wltm,gxmc,bzdj,je,zdh,zhah,shul, bh,ddh ddsl, tmbh,zdkhi,color,csize,shul

¥¿½Tªºsql »yªk¦p¦ó

sammyc

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'