SQL查询结果取值问题

Question

select t1.no as "aNo",[color=red]t3.noCou as "Sum"[/color] from ta t1
left join ([color=darkred]select count(t2.bno) as "noCou",
t2.bno as "bbno"
from tb t2
group by t2.bno[/color]) t3 on [color=red]t3.bbno = t1.ano[/color]

此处为什么不能使用t3.bbno = t1.ano
另外t3.noCou as "Sum"处怎么才能取得临时表t3的列

希望各位在不修改查询语句结构下给点建议

Answer 1

你这句没错啊