表A
ID XM tx
1 A 10
2 B 11
表B
ID XM lx
3 C 12
4 D 13
我要这样的
表B
ID XM tx lx
1 A 10 null
2 B 11 null
3 C null 12
4 D null 13
ID XM tx
1 A 10
2 B 11
表B
ID XM lx
3 C 12
4 D 13
我要这样的
表B
ID XM tx lx
1 A 10 null
2 B 11 null
3 C null 12
4 D null 13
from A
union all
select id,xm,null as tx,lx
from B
from 表A
union all
select ID,XM,NULL,lx
from 表B
insert into A
select 1, 'A', 10 union all
select 2, 'B', 11 create table B(ID int, XM varchar(100), lx int)
insert into B
select 3, 'C', 12 union all
select 4, 'D', 13
select id,xm,tx,null as lx
from A
union all
select id,xm,null as tx,lx
from Bdrop table A,B/*ID XM tx lx
1 A 10 null
2 B 11 null
3 C null 12
4 D null 13
*/
from a
union
select id ,XM, null as tx, lx
from b
insert A select 1,'A',10
union all select 2,'B',11create table B(ID int,XM varchar(10),lx int)
insert B select 3,'C',12
union all select 4,'D',13select ID,XM,tx,lx=null from A
union all
select ID,XM,null,lx from Bdrop table A,B
INSERT INTO @Ta SELECT 1,'A',10
UNION ALL SELECT 2,'B',11DECLARE @Tb Table(ID INT,XM Nvarchar(20),lx int)
INSERT INTO @Tb SELECT 1,'C',12
UNION ALL SELECT 2,'D',13SELECT * FROM @Ta
SELECT * FROM @TbSELECT
X.*
FROM (
SELECT ID,XM,TX=TX,LX=NULL FROM @Ta UNION ALL SELECT ID,XM,TX=NULL,LX=LX FROM @Tb)
SELECT ID,XM,TX=TX,LX=NULL FROM 表A UNION ALL SELECT ID,XM,TX=NULL,LX=LX FROM 表B结果与LZ要求的吻合.