表A
ID A1
1 a1
2 a2
3 a3
表B
ID B1
3 b3
4 b4
5 b5
想要结果
ID A1 B1
1 a1 NULL
2 a2 NULL
3 a3 b3
4 NULL b4
5 NULL b5
如何查询啊？
------解决方案--------------------
- SQL code
declare @表A table (ID int,A1 varchar(2))insert into @表Aselect 1,'a1' union allselect 2,'a2' union allselect 3,'a3'declare @表B table (ID int,B1 varchar(2))insert into @表Bselect 3,'b3' union allselect 4,'b4' union allselect 5,'b5'select isnull(a.ID,b.ID) as ID,a.A1,b.B1 from @表A a full join @表B b on a.ID=b.ID/*ID A1 B1----------- ---- ----1 a1 NULL2 a2 NULL3 a3 b34 NULL b45 NULL b5*/