SQL server 查询 两张表中name字段，显示在一张表中一个字段里

Question

比如说  表A,B中都有 name字段，而且两张表没关系,查询 select name from a,select name from b

将查询出来的结果显示在一张表里的一个字段里面……谢谢各位大虾了……

Answer 1

union  做连接就可以了。

Answer 2

用union  create table table_1 ( id int identity(1,1), name varchar(80) ) create table table_2 ( indexs int identity(1,1), Tname varchar(80) ) insert into table_1(name) values('li') insert into table_1(name) values('zhang') insert into table_1(name) values('wang') insert into table_1(name) values('zhao') insert into table_2(Tname) values('yuan') insert into table_2(Tname) values('fei') insert into table_2(Tname) values('yun') select name from table_1 union select Tname from table_2 结果 name -------------------------------------------------------------------------------- fei li wang yuan yun zhang zhao