select distinct Tab1.name, Tab2.* from Tab1,Tab2 where Tab1.id=Tab2.sid 上面看试正确 ,其实错了,如果分类下没文章,就不读这分类了吗》外连接
if object_id('tempdb..#table1')<>null drop table #table1 if object_id('tempdb..#table2')<>null drop table #table2 select id=1, name='类a' into #table1insert into #table1(id,name)values(2,'类b') insert into #table1(id,name)values(3,'类c') insert into #table1(id,name)values(4,'类d') insert into #table1(id,name)values(5,'类e') insert into #table1(id,name)values(6,'类f')select * from #table1 order by id select id=1, ttl='标题', tin='内容', sid=1 into #table2insert into #table2(id,ttl,tin,sid)values(2,'标题','内容',1) insert into #table2(id,ttl,tin,sid)values(3,'标题','内容',1) insert into #table2(id,ttl,tin,sid)values(4,'标题','内容',2) insert into #table2(id,ttl,tin,sid)values(5,'标题','内容',2) insert into #table2(id,ttl,tin,sid)values(6,'标题','内容',5)
select * from #table2 order by iddeclare @temp_class int set @temp_class=1select t1.id, t2.ttl, t2.tin from #table1 t1 left join #table2 t2 on t1.id=t2.sid where t1.id=@temp_classdrop table #table1 drop table #table2
on a.id=b.sid
http://blog.csdn.net/antiking/archive/2007/04/24/1579855.aspx
drop table #table1
if object_id('tempdb..#table2')<>null
drop table #table2
select
id=1,
name='类a'
into
#table1insert into #table1(id,name)values(2,'类b')
insert into #table1(id,name)values(3,'类c')
insert into #table1(id,name)values(4,'类d')
insert into #table1(id,name)values(5,'类e')
insert into #table1(id,name)values(6,'类f')select * from #table1 order by id
select
id=1,
ttl='标题',
tin='内容',
sid=1
into
#table2insert into #table2(id,ttl,tin,sid)values(2,'标题','内容',1)
insert into #table2(id,ttl,tin,sid)values(3,'标题','内容',1)
insert into #table2(id,ttl,tin,sid)values(4,'标题','内容',2)
insert into #table2(id,ttl,tin,sid)values(5,'标题','内容',2)
insert into #table2(id,ttl,tin,sid)values(6,'标题','内容',5)
select * from #table2 order by iddeclare @temp_class int
set @temp_class=1select
t1.id,
t2.ttl,
t2.tin
from #table1 t1
left join #table2 t2
on t1.id=t2.sid
where t1.id=@temp_classdrop table #table1
drop table #table2