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现在报消息 207,级别 16,状态 3,第 1 行
列名 'TCount' 无效。
我想得出TCount*LT_PART_COUNT两个字段相乘的总数 该 怎么写呢?
列名 'TCount' 无效。
我想得出TCount*LT_PART_COUNT两个字段相乘的总数 该 怎么写呢?
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
from (
select count(*) as TCount,
...
)T
from LI_TICKET,LI_TICKET_SALE
where LT_ID=TS_TID and TS_TID='80' group by LT_PART_COUNT,TS_TID
from LI_TICKET,LI_TICKET_SALE where LT_ID=TS_TID and TS_TID='80' group by LT_PART_COUNT,TS_TID