SELECT sum(StuBookNum)AS学生总订量,sum(TeaBookNum)AS教师总订量,
(SUM(StuBookNum)+sum(TeaBookNum) )AS 总订量
FROM T_BookInfo ,T_BookOrder
WHERE T_BookInfo.BookCode=T_BookOrder.BookCode AND BookName='VB程序设计'
DELETEFROMNewTable1
WHERE StuBookNum+TeaBookNumnext)应该是while(rs->next)add:==<<但是为什么在后面加个orderbysum(f_long)desc就不好使了呢哪位高手知道啊？怎么进行排序啊！帮个忙你可以在你最外面再包装个select语句的啊select...
