高手帮我看一下这个问题

来源：百度知道 编辑：UC知道 时间：2024/05/29 00:12:58
select e.mc,
(select 数据 from e where mc=e.mc and bz='KH01_工资补贴') as 工资补贴,
(select 数据 from e where mc=e.mc and bz = 'KH02_保险')as 保险,
(select 数据 from e where mc=e.mc and bz = 'KH03_奖金')as 奖金,
(select 数据 from e where mc=e.mc and bz = 'KH04_个人家庭补助')as 个人家庭补助,
(select 数据 from e where mc=e.mc and bz = 'KH04_个人家庭补助')as 其他公用支出,
(select 数据 from e where mc=e.mc and bz = 'KH05_卫生材料')as 卫生材料,
(select 数据 from e where mc=e.mc and bz = 'KH06_药品费')as 药品费,
(select 数据 from e where mc=e.mc and bz = 'KH07_房屋折旧')as 房屋折旧,
(select 数据 from e where mc=e.mc and bz = 'KH08_专业设备折旧')as 专业设备折旧,
(select 数据 from e where mc=e.mc and bz = 'KH09_其他设备折旧')as 其他设备折旧,
(select 数据 from e where mc=e.mc and bz = 'KH10_维修费')as 维修费,
(select 数据 from e where mc=e.mc and bz = 'KH11_其他公用支出')as 其他公有支出
into #tb2
from #tb1 e

#tb1是我建立的一个临时表,里面有数据,可以查询出来,这边就不赘述了.但

因为你在子查询中是不能通过from使用主查询中的别名
(select 数据 from e ....)这一句有错，

修改如下：
select e.mc,
(select 数据 from #tb1 where mc=e.mc and bz='KH01_工资补贴') as 工资补贴,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH02_保险')as 保险,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH03_奖金')as 奖金,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH04_个人家庭补助')as 个人家庭补助,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH04_个人家庭补助')as 其他公用支出,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH05_卫生材料')as 卫生材料,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH06_药品费')as 药品费,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH07_房屋折旧')as 房屋折旧,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH08_专业设备折旧')as 专业设备折旧,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH09_其他设备折旧')as 其他设备折旧,
(select 数据 from #tb1 where mc=e.mc and bz = 'KH10_维修费')as 维修费,
(select 数据 from #tb1 where mc=e.mc