SQL语句如下:select count(*) as TCount, LT_PART_COUNT,TS_TID,(TCount*LT_PART_COUNT) as Total from LI_TICKET,LI_TICKET_SALE where LT_ID=TS_TID and TS_TID='80' group by LT_PART_COUNT,TS_TID现在报错TCount无效; 我现在需求想将求出TCount的值乘以LT_PART_COUNT 得出总数 该怎么写呢?
调试欢乐多
---
还有个问题LT_PART_COUNT不在分组字段里面,这个取会报错的。
可以改成max((TCount*LT_PART_COUNT) ),或是sum(TCount*LT_PART_COUNT)
from LI_TICKET,LI_TICKET_SALE where LT_ID=TS_TID and TS_TID='80' group by LT_PART_COUNT,TS_TID
select count(*) as TCount,LT_PART_COUNT,TS_TID,(count(*)*LT_PART_COUNT) as Total
from LI_TICKET,LI_TICKET_SALE where LT_ID=TS_TID and TS_TID='80' group by LT_PART_COUNT,TS_TID点快了吧 网卡了