摘要:
declare @mytable table( productId int, bigClassId int, aField int )insert into @mytable select top 10 productid,bigClassid,count(id)+sum(supportNum) as aField from tbcomments group by productid,bigclassid order by aField desc(select t.name,p.aField from tbTravel_Info t,@mytable as p where t.id=p.pro 阅读全文
posted @ 2011-01-27 15:10 一刻 阅读(159) 评论(0) 推荐(0) 编辑