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

ÈçºÎ´ÓACCESSÊý¾Ý¿âÖÐÒ»´Î²éѯ¶à¸ö±í²¢¼ÓÈëÊý¾Ý¼¯?

ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾Ý¿â¾Í»á±¨´í£¬ACCESS²»Ö§³Ö·ÖºÅÂð£¿
¸ÃÈçºÎ¸ÄÄØ£¿
²»ÐÐ

²»Ö§³Ö¡£¡£¡£Ò»ÌõÒ»ÌõÀ´°É

ACCESS²»Ö§³ÖÕâ¸ö¹¦ÄÜ,±È½ÏACCESSÖ»ÊÇÇáÁ¿¼¶µÄÊý¾Ý¿â

¿ÉÒԵġ£
SELECT  tbl_choicevice.*, tbl_information.*, tbl_operation.*, tbl_public.*
from      (tbl_choicevice INNER JOIN
                tbl_public ON tbl_choicevice.C_recno = tbl_public.C_Recno), tbl_operation, tbl_information


Èç¹ûÓÐÊý¾ÝÏîÏàͬ¾Í»á³öÏÖºóÃæÒªµÈµÄÇé¿ö¡£

¿ÉÒԵģº
SELECT  A.*, B.*, C.* from      A, B, C

Â¥ÉÏÊÓÁ¦²»¼Ñ£¿


Ïà¹ØÎÊ´ð£º

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×ֶΠfrom ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËٶȣ¡
Ò»´ÎÈ«²¿¶ÁÍê ......

¸ßÈ˽ø £¡£¡access Êý¾Ý¿âÎÊÌâ~~

±í½á¹¹£º
ProductSeriesID ×Ô¶¯±àºÅ
ProductSeriesName Îı¾
ProductSeriesRemark ±¸×¢

Ö´ÐÐÇ°
ProductSeriesID ProductSeriesName ProductSeriesRemark
2 LVϳµ¶ÏµÁÐ LVϳµ¶ÏµÁÐ
3 ÎÙ¸ÖÉá ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃÇ°ïÖúС°×²ËÎÒ


Microsoft O ......

50ÍòÌõÊý¾ÝACCESSÊý¾Ý¿â,Ä£²éѯÓÐʲô·½·¨ÄÜ¿ìЩ...

ÎÒÓÃÁËÒ»°ãµÄ²éѯÓï¾ä³öÀ´,,,ÍÛºÃÂý°¡................



ʹÓÃ×é¼þ

DBgrid  ADOQuery  DATASOurce

¿ì²»ÁË£¬Ö»Äܾ¡¿ÉÄܵÄÓÅ»¯°É
ÓÅ»¯Êý¾Ý½á¹¹£¬½¨Ë÷Òý£¬²»¹ý½¨Òé²»ÒªÒ»´Î¶Á³öËùÓ ......

ÈçºÎ¶ÁÈ¡ÕâÖÖÊý¾Ý£¬ÔÚaccessÀïÃæ¡£Çó½Ì¸ßÊÖ

ÎÒµÄÒ»¸öaccessÊý¾Ý¿âÖеÄphoto×Ö¶ÎÖеÄÄÚÈÝÊÇÕâÑùµÄ£º

|/UpFiles/Picture/admin/200910162300187612.jpg|/UpFiles/Picture/admin/200910162300187612.jpg||||/UpFiles/Picture/admin/200910162300187612.jpg ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ