ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

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

¥»©«³Ì«á¥Ñ sammyc ©ó 2011-2-21 16:43 ½s¿è

·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¦ó
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¤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

TOP

¦bexcel¤¤¡A¶i¶¥¿z¿ï´N¯à§¹¦¨¦¹Ãþ¤u§@
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

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'
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD