select * from table1 a full join table2 b on a.id=b.id
declare @table1 table (id int,v1 varchar(20)) declare @table2 table (id int,v2 varchar(20))insert @table1 values (1,'a') insert @table1 values (2,'b') insert @table1 values (3,'c')insert @table2 values (1,'a') insert @table2 values (2,'b') insert @table2 values (4,'d') select id=isnull(a.id,b.id),v1=isnull(v1,''),v2=isnull(v2,'') from @table1 a full join @table2 b on a.id=b.idid v1 v2 ----------- -------------------- -------------------- 1 a a 2 b b 4 d 3 c (所影响的行数为 4 行)
(id int,v1 varchar(20))
declare @table2 table
(id int,v2 varchar(20))insert @table1 values (1,'a')
insert @table1 values (2,'b')
insert @table1 values (3,'c')insert @table2 values (1,'a')
insert @table2 values (2,'b')
insert @table2 values (4,'d')
select id=isnull(a.id,b.id),v1=isnull(v1,''),v2=isnull(v2,'') from @table1 a full join @table2 b on a.id=b.idid v1 v2
----------- -------------------- --------------------
1 a a
2 b b
4 d
3 c (所影响的行数为 4 行)