如果把下面两句关联到一起。写成一条语句 HELP

select Intro,Title,Fname from KS_Article where Recommend=1 and tid in ('20089708023405','20083009516777','20084565021540','20088153540916','20085926314284','20081973302208','20085248190327')

select Folder from Ks_class where id in ('20089708023405','20083009516777','20084565021540','20088153540916','20085926314284','20081973302208','20085248190327')

最终我是使用下边语句实现的

select top 10 KS_Article.Intro,KS_Article.Title,KS_Article.Fname,Ks_class.Folder from KS_Article LEFT join Ks_class on KS_Article.tid=Ks_class.id where KS_Article.Recommend=1 and KS_Article.tid in ('20089708023405','20083009516777','20084565021540','20088153540916','20085926314284','20081973302208','20085248190327') order by KS_Article.id desc

Ks_class.tn='{$CurrClassID}'

这跟父栏目有什么关系。。。

不明白。楼上的能给讲详细些吗？

where KS_Article.Recommend=1 and KS_Article.tid=Ks_class.id and and Ks_class.tn='{$CurrClassID}'

这个啊。

select KS_Article.Intro,KS_Article.Title,KS_Article.Fname,Ks_class.Folder from KS_Article where KS_Article.Recommend=1 inner join Ks_class on KS_Article.tid=Ks_class.id where order by KS_Article.id desc

where 条件怎么加啊。

LZ。你可以试试这样写：

select KS_Article.Intro,KS_Article.Title,KS_Article.Fname,Ks_class.Folder,Ks_class.ID from KS_Article,Ks_class where KS_Article.Recommend=1 and KS_Article.tid=Ks_class.id and and Ks_class.tn='{$CurrClassID}' order by KS_Article.id desc

select KS_Article.Intro,KS_Article.Title,KS_Article.Fname,Ks_class.Folder from KS_Article where KS_Article.Recommend=1 and KS_Article.tid in ('20089708023405','20083009516777','20084565021540','20088153540916','20085926314284','20081973302208','20085248190327') inner join Ks_class on KS_Article.tid=Ks_class.Folder order by KS_Article.id desc

这样写对吗？

[此贴子已经被作者于2008-1-10 12:40:01编辑过]