Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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

oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......

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

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

ÎÊÒ»¸öºÜÈõµÄaccessÎÊÌâ - ÆäËûÊý¾Ý¿â¿ª·¢ / Access

дaspÍøÕ¾µÄʱºò£¬ÔÚÍøÉÏÏÂÁ˸öÄ£°å£¬ËûµÄÊý¾Ý¿âÖÐÓÐÒ»¸öid×ֶΣ¬ÔÚaccessÖÐÕâ¸ö×ֶεÄÊÇ×Ô¶¯±àºÅµÄ£¬²»ÄÜÐ޸ģ¬Ìáʾ˵¿Ø¼þÒѰ󶨣¬ÇëÎÊ´ó¸ç¸ç´ó½ã½ãÃÇ£¬ÈçºÎÈ¡ÏûÕâ¸ö°ó¶¨......
ÄãÏëÐ޸ijÉʲô£¿
QQȺ 48866293 / ......

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

VS2008ÖÐC#²Ù×÷AccessÊý¾Ý¿â£¬ÍøÉÏÏÂÔØÁËÒ»¸öÀ࣬¿ÉÒÔÕý³£Á¬½Ó£¬¶ÁÈ¡Êý¾Ý£¬µ«ÊDzåÈëɾ³ý²Ù×÷ËÆºõÓÐÎÊÌ⣬ÒÔÏÂÊDz¿·Ö´úÂ룺
Êý¾Ý¿âÀࣺ
namespace AccessDb
{
  public class AccessDbClass
  { ......

¹ØÓÚAccess Êý¾Ý¿â - .NET¼¼Êõ / C#

ÎÒÏëдһ¸öµ¥»úͳ¼Æ¹¤×÷Á¿µÄ³ÌÐò£¬µ«Ö§³Ö¶àÕÊ»§Ê¹ÓÃ,·½±ãÐ޸ġ¢²éѯ¡¢Í³¼Æ¡£ËùÒÔÏëÓõ½Access,ÒªÔõô×ö±È½ÏºÃ£¬ÎÒ»¹Ã»ÓÐ×ö¹ý¹ØÓÚÊý¾Ý¿â·½ÃæµÄ³ÌÐò¡£Çë´ó¼Ò¸øÎÒÒ»¸ö˼·°¡!Ö÷ÒªÊÇÊý¾Ý¿âÕâÒ»¿é.
Ê×ÏÈÒª×öºÃÐèÇóµÄ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ