将两个表联合 插入到一个临时表

select * into #aa from (select ShiJiRuJingShiJian,RuJingShiChang,RenYuanBianHao from T_CHURUJINGJILU_10unionselect ShiJiRuJingShiJian,RuJingShiChang,RenYuanBianHao from T_CHURUJINGJILU_11) a

 

括号 和 别名a 一定要有