一个简单SQL语句报错 求解!下班结帖

[happy664618843]

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两个字段相乘的总数 该 怎么写呢?

[kingtiy]

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*LT_PART_COUNT)

[mustudent]

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

[rucypli]

select Tcount
from (
select count(*) as TCount,
...
)T

[cd731107]

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

[快溜]

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

[zy35147972122]

自己命名的列名是不能在查询语句其他地方使用的，只有在将他保存到一个表中时才能使用

[jxqn_liu]

TCount在执行的时候都还没有成型呢，不能使用！

[xuyuchends]

lz你下班结贴，问题是哪天下班结贴呢？

[happy664618843]

[Quote=引用 8 楼 xuyuchends 的回复:]

lz你下班结贴，问题是哪天下班结贴呢？
[/Quote]
哎 各位真不好意思 忘记了