select newid
from news a
subclass b
class c
where c.classid ='你选中的'
b.classid =c.classid
b.subclassid = c.subclass
a.classid = b.classid
from news a
subclass b
class c
where c.classid ='你选中的'
b.classid =c.classid
b.subclassid = c.subclass
a.classid = b.classid
提示说'subclass' 附近有语法错误好像不行啊
top(5) a.classid,b.subclass,c.newid
from
news as c
inner join
subclass as b on b.subclass = c.subclass and b.classid= c.classid
inner join
class as a on b.classid = a.classid
where
c.classid=@classid and c.subclass=@subclass