[¤v¸Ñ¨M] ¥Ñ¤TÓ¸ê®Æªí¥X¸ê®ÆSQL»yªk
- ©«¤l
- 33
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 62
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-17
- ³Ì«áµn¿ý
- 2020-11-2
|
[¤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
|
|
|
|
|
- ©«¤l
- 116
- ¥DÃD
- 5
- ºëµØ
- 0
- ¿n¤À
- 190
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- office 2002
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2010-11-17
- ³Ì«áµn¿ý
- 2024-10-27
|
¤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 |
|
|
|
|
|
|
- ©«¤l
- 33
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 62
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-17
- ³Ì«áµn¿ý
- 2020-11-2
|
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
|
|
|
|
|