ÓÃC#¶ÔAccessÊý¾Ý¿â²éѯÎÊÌâ
ÎÒÏëÎÊÎÊ£¬ÔÚc#±àдµÄ¶ÔAccessÊý¾Ý¿â²Ù×÷µÄ³ÌÐòÖУ¬±àдʲô´úÂë¿ÉÒÔ¶ÔAccessÊý¾Ý¿âÖеÄÁ½¸ö±í½øÐвéѯ£¿£¿£¿
End_rbody_61188804//-->
¸Ã»Ø¸´ÓÚ2009-11-17 09:09:27±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
starj1
(ľ¹Å¿ÚÊ®)
µÈ¡¡¼¶£º
#2Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2009-11-16 03:28:34
¶þ¸ö±íÁªºÏ²éѯµÄ×Ӿ䣺
left join/inner join/right join/join on table1.key = table2.key
Ïà¶ÔÓÚMS SQLÀ´½²£¬AccessµÄ¹¦ÄÜÉÔ΢ÈõÁËһЩ£¬²»¹ý»¹ÊÇ¿ÉÒÔÍê³É»ù±¾ÊµÏÖ¡£ÖÁÓÚ¶ÔÊý¾Ý¿âµÄ¶ÁдÓëMS SQL ²î±ð²¢²»ÊǺܴó¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......
ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏÂ
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡±
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......
ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......