如何利用查询获得两个表合起来之后的结果？

Question

select field1,field2,field3,field4,field5,[field6]=null from table1
union
select field1,field2,null,field4,field5,field6 from table2

Answer 1

select field1,field2,field3,field4,field5,[field6]=null from table1
union all
select field1,field2,null,field4,field5,field6 from table2

Answer 2

create table table1(
field1 int,
field2 int
)create table table2(
field1 int,
field3 int
)insert into table1 values(1,1)
insert into table1 values(2,2)insert into table2 values(3,3)
insert into table2 values(4,4)--创建临时表
create table #t(field1 int,field2 int,field3 int)insert into #t(field1,field2) select * from table1
insert into #t(field1,field3) select * from table2select * from #t

Answer 3

select field1 , field2 , field3 , field4 , field5, null as field6 from table1 
union all
select field1 , field2 , null as field3 , field4 , field5, field6 from table2

Answer 4

select field1,field2,field3,field4,field5,null as field6 from table1
union all
select field1,field2,null as field3,field4,field5,field6 from table2
order by field1

Answer 5

楼主用的是连接(join)而非联合(union)