create table cat(cid int)
go
create table art(a_cid int,name varchar(200))
goinsert into cat values(1)
insert into cat values(2)
insert into cat values(3)
goinsert into art values(1,'第一篇')
insert into art values(1,'第二篇')
insert into art values(1,'第三篇')
insert into art values(2,'第一篇')
insert into art values(2,'第二篇')
insert into art values(3,'第一篇')
go
select *
from cat,art t
where cid=a_cid and name =(select top 1 name from art where a_cid=t.a_cid order by name)
go
create table art(a_cid int,name varchar(200))
goinsert into cat values(1)
insert into cat values(2)
insert into cat values(3)
goinsert into art values(1,'第一篇')
insert into art values(1,'第二篇')
insert into art values(1,'第三篇')
insert into art values(2,'第一篇')
insert into art values(2,'第二篇')
insert into art values(3,'第一篇')
go
select *
from cat,art t
where cid=a_cid and name =(select top 1 name from art where a_cid=t.a_cid order by name)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货