下面的语句应该是能简化的吧?俺菜不知如何下手,还望高人们指点一二~~~select
BookID,Hits,BookPic,(select top 1 charptername from [TabA] where TabB.Bookid=TabA.Bookid) as LastUpdate,(select top 1 Soundid from [TabA] where TabB.Bookid=TabA.Bookid) as UpdateID,(select sum(VIP) from [TabA] where TabB.Bookid=TabA.Bookid) as VIP,(select sum(VIP2) from [TabA] where TabB.Bookid=TabA.Bookid) as VIP2 from [TabB]order by Bookid desc
b.BookID,b.Hits,b.BookPic,
max(a.charptername) as LastUpdate,
max(a.Soundid) as UpdateID,
sum(VIP) as VIP,
sum(VIP2) as VIP2
from [TabB] b
Join TabA a on a.Bookid = a.Bookid
group by b.BookID,b.Hits,b.BookPic
order by b.Bookid