看一下有问题吗？（临时表）

Question

不能这样赋值的。
create table #t(barid_i varchar(100),barname_c nvarchar(100), click_i varchar(100))
insert into #t(barid_i)
select barid_i from bardance
insert into #t(barid_i)
select barid_i from barsong
insert into #t(barname_c)
select barname_c from barinfo where barinfo.autoid in(select barid_i from bardance)insert into #t(click_i)
select barname_c from barinfo where barinfo.autoid in(select barid_i from bardance)select top 10  barname_c,click_i 
from #t 
group by barid_i,barname_c,click_i  
order by count(barid_i) desc
drop table #t