[¤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¦ó

aa7551

¤j¤j©Ò½Íªº,À³¥i¥Ñ¤l¬d¸ß§¹¦¨,¬O§_¥i§¹¾ã¦C¥X¤Gªí®æ¦UÄæ¦ì,select aa ,(select bb from b where ab.b=ab.a) as bb ,(select cc from c where ac.c=ac.a) as ac from a

Hsieh

¦bexcel¤¤¡A¶i¶¥¿z¿ï´N¯à§¹¦¨¦¹Ãþ¤u§@

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'