select a.user_id,a.user_dpt,a.user_birthday from a union all select b.user_id,b.user_deparment,b.birthday from b
select into #temp from ( select a.user_id,a.user_dpt,a.user_birthday from a union all select b.user_id,b.user_deparment,b.birthday from b)
union部分没有问题,放入表中就出现问题了
唉,Try: select into #temp from ( select a.user_id,a.user_dpt,a.user_birthday from a union all select b.user_id,b.user_deparment,b.birthday from b) c
select a.userid,a.userdpt,a.userbirthday into #tmp from( select user_id,user_dpt,user_birthday from t1 union select user_id,user_deparment,birthday from t2 )a
union all
select b.user_id,b.user_deparment,b.birthday from b
select a.user_id,a.user_dpt,a.user_birthday from a
union all
select b.user_id,b.user_deparment,b.birthday from b)
select into #temp from (
select a.user_id,a.user_dpt,a.user_birthday from a
union all
select b.user_id,b.user_deparment,b.birthday from b) c
into #tmp
from(
select user_id,user_dpt,user_birthday from t1
union
select user_id,user_deparment,birthday from t2
)a