如下:
表一:
id firstname
1 aaa
2 bbb
3 ccc
表二:
id lastname
1 ddd
2 eee
3 fff
我想建一张临时表,输出结果为:(#template )
表三: firstname
aaa
bbb
ccc
ddd
eee
fff或者用存储过程也可以,请问各位怎么做?
表一:
id firstname
1 aaa
2 bbb
3 ccc
表二:
id lastname
1 ddd
2 eee
3 fff
我想建一张临时表,输出结果为:(#template )
表三: firstname
aaa
bbb
ccc
ddd
eee
fff或者用存储过程也可以,请问各位怎么做?
union
select lastname as firstname from table2
Union All
Select lastname as UserName From 表2
union
select lastname from 表二