Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASPÊý¾Ý¿â²éѯÁ¬±íÎÊÌâ~~~~~~~~~

a±íÖÐÓвúÆ·±àºÅ£¬b±íÖÐÒ²ÓÐÓвúÆ·±àºÅ£¬ÏÖÔÚÁ½¸ö±íÁ¬ÔÚÒ»Æð£¬µ«Ö»ÐèÒªÒ»¸ö²úÆ·±àºÅµÄÁÐÃû£¬£¨²»ÓÃa.²úÆ·±àºÅ»òb.²úÆ·±àºÅÄÇÖÖ£©~~~~~
ÄãÒªÔõôÁ¬£¿Ìõ¼þ¶¼Ã»Ëµ£¿2¸öIDÏàµÈΪÌõ¼þ£¿

¶Ô~~ÒÔËûÃǵIJúÆ·±àºÅΪÌõ¼þ~~~ÊÇSQL2000µÄ~~£¬£¨²»ÓÃa.²úÆ·±àºÅ»òb.²úÆ·±àºÅÄÇÖÖÁ¬½Ó·½·¨£©~~~~~




Ò²¾ÍÊÇ説Á¬½Óʱ°ÑÒ»¸ö²úÆ·±àºÅÈ¥µô

¿´£¬ÄÇÊÇÔÚÄã¶ÁµÄʱºò²»Òª¶ÁÒ»¸ö²»¾ÍÍêÁË
select a*,b.ÆäËû×Ö¶Î from table a left join b on a.²úÆ·ID=b.²úÆ·ID

ÒýÓÃ
¿´£¬ÄÇÊÇÔÚÄã¶ÁµÄʱºò²»Òª¶ÁÒ»¸ö²»¾ÍÍêÁË
select a*,b.ÆäËû×Ö¶Î from table a left join b on a.²úÆ·ID=b.²úÆ·ID

¶î~~Óеã½Ó½ü~~²»¹ý~~ÎÒµÄÒâ˼ÊÇÔÚÁ¬±íʱ¾Í°Ñ²úÆ·±àºÅÈ¥µô~~¡°select "&±äÁ¿&"(ÕâÀïÖ»ÓÐÒ»¸ö±äÁ¿) from....¡±ËùÒÔÎÒ²ÅÒª°ÑÒ»¸ö²úÆ·±àºÅÈ¥µô£¬²»È»£¬µçÄÔ·Ö²»Çå²úÆ·±àºÅÊôÓÚÄĸö±í°¡~~~


ÒýÓÃ
ÒýÓà 4 Â¥ chinmo µÄ»Ø¸´:
¿´£¬ÄÇÊÇÔÚÄã¶ÁµÄʱºò²»Òª¶ÁÒ»¸ö²»¾ÍÍêÁË
select a*,b.ÆäËû×Ö¶Î from table a left join b on a.²úÆ·ID=b.²úÆ·ID

¶î~~Óеã½Ó½ü~~²»¹ý~~ÎÒµÄÒâ˼ÊÇÔÚÁ¬±íʱ¾Í°Ñ²úÆ·±àºÅÈ¥µô~~¡°select "&±äÁ¿&"(ÕâÀïÖ»ÓÐÒ»¸ö±äÁ¿) from....¡±ËùÒÔÎÒ²ÅÒª°ÑÒ»¸ö²úÆ·±àºÅÈ¥µô£¬²»È»£¬µçÄÔ·Ö²»Çå²úÆ·±àºÅÊôÓÚÄĸö±í°¡~~~


lzΪʲôÌáÈ¡Êý¾ÝµÄʱºò×ÜÓÃÕâÖÖ·½·¨ÄØ£¿
ÓÃlfet join ÒѾ­È·¶¨ÁËÕâ¸ö²úÆ·idÊÇ´ÓA±íÖжÁÈ¡³öÀ´µÄ°¡£¿


û°ì·¨°¡~~ÀÏʦ¸øµÄÄÑÌâ~~Æäʵ~~ÎÒÒ²ÊÇͦÓôÃÆµÄ~~´ó¼Ò~·°ï°ïæßÂ~~~

±äÁ¿ÊdzÌÐò²úÉ


Ïà¹ØÎÊ´ð£º

ÎÒÏë×öÒ»¸öaspÍøÕ¾£¬µ«ÊDz»ÖªµÀ×öʲô£¡

×î½üÎÒͨ¹ýѧϰ£¬¸Ð¾õ×Ô¼ºÑ§µÄ»¹¿ÉÒÔÁË£¬Ïë×öÒ»ÍøÕ¾£¬µ«ÊÇÒ»Ö±¶¼ÕÒ²»µ½Ìâ²Ä£¬²»ÖªµÀ×öʲô£¬Ï£Íû¸÷λ¸øÎÒµãÒâ¼û£¬Èç¹ûÓÐÐèÇóÎĵµ¾Í¸üºÃÁË£¡Ï£Íû´ó¼Ò¸øÎÒµãÒâ¼û£¬Ð»Ð»£¡
ÏÈ×ö¸öÆóÒµÍøÕ¾°É£¬ÎҸоõÒ»¸öÈË×öÍøÕ¾²»ÊÊÒË ......

ÎÒÊÇÒ»ÃûASP´¦Ñ§Õߣ¡ÏëÇë°ïÃ¦ÍÆ¼öÒ»±¾ASPºÃµÄÊé¼®

ÎÒÔ­±¾ÊÇѧjspµÄ¿ÉÕÒÁËÒ»¸öASPµÄ¹«Ë¾£¡ÎÒÒªÖØÐÂѧϰ£¡ ѧϰASP£¡ Ï£Íû´ó¼ÒÍÆ¼öÒ»±¾ºÃÊ鏸ÎÒлл
<ASP3.0¸ß¼¶±à³Ì> ÍøÉÏÓеç×Ó°æµÄ

·¢ÏÖÍøÉÏaspÐÅϢʱ×î¶àµÄ ±ÈÆäËûµÄ¶¼¶àºÃ¶à

yun

ÕÒ±¾ÓÐÓ¦ÓÃÊÂÀýµÄA ......

ASP網頁ÖÐÈ¡µÃµÇ陸µÄÓÃ戶Ãû

ÎÒµÄ網頁´ú碼為ASP語ÑÔ,驗證·½Ê½為ϵ統×Ô帶µÄWINDOW驗證ģʽ.

現ÔÚÎÒÈç¹ûÒªÔÚASP´ú碼ÖÐ獲È¡當ǰµÄµÇÈëÈË ......

aspºǫ́µÇ½ÎÊÌâ

ÎÒ°ïѧУ×öÁËÒ»¸öÕ¾£®

ÔÚÐ£Ô°ÍøµÄÇé¿öÏ£¬Äܹ»µÇ½³É¹¦£¬ºǫ́ÕʺŶ¼ÄÜͨ¹ý£¬½øÈëºǫ́

µ«ÊÇÔÚÍâÍø£Á£ÄµÄÇé¿öÏ£¬Äܹ»µÇ½ºǫ́µÄÒ³Ãæ£¬Ò³ÃæÊÇ£Á£Ó£ÐÎļþ£®
µ«ÊÇÊäÈëÕʺźÍÃÜÂëµÄʱºò£¬ÍøÒ³ÔËÐкܾö¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ