select * into #aa from
(
select ShiJiRuJingShiJian,RuJingShiChang,RenYuanBianHao from T_CHURUJINGJILU_10
union
select ShiJiRuJingShiJian,RuJingShiChang,RenYuanBianHao from T_CHURUJINGJILU_11
) a
括号 和 别名a 一定要有
select * into #aa from
(
select ShiJiRuJingShiJian,RuJingShiChang,RenYuanBianHao from T_CHURUJINGJILU_10
union
select ShiJiRuJingShiJian,RuJingShiChang,RenYuanBianHao from T_CHURUJINGJILU_11
) a
括号 和 别名a 一定要有