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_