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

accessÖÐ2±í²éѯ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

http://topic.csdn.net/u/20100515/17/02ba7650-e32d-40e9-90c6-afda0efd2e40.html?seed=1635730994&r=65479377#r_65479377
µ½´¦Çó¾È~~ Ï£ÍûÄܽâ¾öÏ£¬Ö»Ê£ÏÂÕâôµã·ÖÁË¡£
µÝ¹é²éѯ£¬ÒªÓÃVBAÀ´ÊµÏÖ


Select t.* from T_Kind t,T_P p where t.K_ID = p.P_Kind

²»ÊÇÄãÏëÒªµÄ½á¹ûÂð£¿Èç¹û²»ÊÇ£¬ÄÇÄãÏëÒªµÄ½á¹ûÊÇʲôÑù£¿

ÒýÓÃ
Select t.* from T_Kind t,T_P p where t.K_ID = p.P_Kind

²»ÊÇÄãÏëÒªµÄ½á¹ûÂð£¿Èç¹û²»ÊÇ£¬ÄÇÄãÏëÒªµÄ½á¹ûÊÇʲôÑù£¿

SQL code:

create table T_K
(
K_ID int identity(1,1) primary key not null,
K_Name varchar(30),
K_Kind int default 0
)

select * from T_Kind

insert into t_k(K_Name)values('Çò')
insert into t_k(K_Name,K_Kind)values('ÀºÇò','1')
insert into t_k(K_Name,K_Kind)values('×ãÇò','1')
insert into t_k(K_Name)values('ÈË')

create table T_P
(
P_ID int identity(1,1) primary key not null,
P_Name varchar(30),
P_Kind int,
P_Image varchar(40),
P_Content Text,
P_AddDate datetime
)

insert into t_p(P_Name,P_Kind,P_Image,P_Content,P_AddDate)values('ƹÅÒÇò','1','../img/a.jpg','pingpangqiu','2010-5-15')
insert into t_p(P_Name,P_Kind,P_Image,P_Content,P_AddDate)values('NBA','2','../img/b.jpg','pingpangqiu','2010-5-15')
insert into t_p(P_Name,P_Kind,P_Image,P_Content,P_AddDate)values('ÄÐÈË','4','../img/c.jpg','pingpangqiu','2010-5-15')

ÏÖÔÚ¸ù¾ÝT_


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

ÎÒÓÃAccessÊý¾Ý¿â×öÁËÒ»¸öͼÊéÊý¾Ý¿â£¬ÀïÃæÓÐÒ»¸ö×Ö¶ÎÊÇISBN£¬¾ÍÊÇISBNºÅ£¬µ«ÊÇÖ»µÄÒ»×Ü·ÖͼÊéдµÄISBNºÅ£¬ÓеÄûд£¬Ð´µÄÄÇÒ»²¿·ÖÓеÄISBNÊÇÖØ¸´µÄ£¬ÄÜ·ñÓÃSQLÓïÑÔ°ÑÖØ¸´µÄ¹ýÂ˵ô£¬µ«Ã»Ð´ISBNºÅµÄͼÊé²»ÄܹýÂ˵ô£¬È ......

ACCESS Êý¾Ý²éѯÎÊÌâ ÔÚÏßµÈ - Web ¿ª·¢ / ASP

ÏÂÃæÊÇÊý¾Ý
ID Money PID
1 50  
2 40 1
3 30 1
4 ......

½«excelÊý¾Ýµ¼Èë Access ÎÊÌâ - VB / »ù´¡Àà

ÓÃVB³ÌÐòÖн«excelµÄÎļþ·ÅÔں͹¤³Ìͬһ¸öÎļþ¼ÐÖУ¬µ¼ÈëʱûÓдíÎ󣬵«ÔÚ±ðµÄĿ¼Ïµ¼Èë¾Í»á³öÏÖ´íÎó
Ìáʾ£º Ö÷¹Ø¼ü×ÖÖØ¸´£¨Õâ¸öÅжÏÎÒÔÚ³ÌÐòÖмÓÁË£¬ÔÚºÍACCESSͬһĿ¼ÏÂʱû³öÏÖ´íÎó£©
  Common ......

VS2008²Ù×÷AccessÎÊÌâ - .NET¼¼Êõ / C#

VS2008ÖÐC#²Ù×÷AccessÊý¾Ý¿â£¬ÍøÉÏÏÂÔØÁËÒ»¸öÀ࣬¿ÉÒÔÕý³£Á¬½Ó£¬¶ÁÈ¡Êý¾Ý£¬µ«ÊDzåÈëɾ³ý²Ù×÷ËÆºõÓÐÎÊÌ⣬ÒÔÏÂÊDz¿·Ö´úÂ룺
Êý¾Ý¿âÀࣺ
namespace AccessDb
{
  public class AccessDbClass
  { ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ