表一如:
ID A B C D
1 2 3 5 6
2 4 5 0 7
3 5 6 8 9
4 3 4 1 4表二如:
ID A B C D
3 1 3 5 6
4 4 1 0 7
5 2 6 4 8
6 3 7 1 4最总两表合并为表三如:ID A B C D A B C D
1 2 3 5 6 0 0 0 0
2 4 5 0 7 0 0 0 0
3 5 6 8 9 1 3 5 6
4 3 4 1 4 4 1 0 7
5 0 0 0 0 2 6 4 8
6 0 0 0 0 3 7 1 4
合并表的select语句是什么?
ID A B C D
1 2 3 5 6
2 4 5 0 7
3 5 6 8 9
4 3 4 1 4表二如:
ID A B C D
3 1 3 5 6
4 4 1 0 7
5 2 6 4 8
6 3 7 1 4最总两表合并为表三如:ID A B C D A B C D
1 2 3 5 6 0 0 0 0
2 4 5 0 7 0 0 0 0
3 5 6 8 9 1 3 5 6
4 3 4 1 4 4 1 0 7
5 0 0 0 0 2 6 4 8
6 0 0 0 0 3 7 1 4
合并表的select语句是什么?
isnull(a.id,b.id) as id
isnull(a.a,0) as a, isnull(a.b,0) as b, isnull(a.c,0) as c, isnull(a.d,0) as d,
isnull(b.a,0) as a, isnull(b.b,0) as b, isnull(b.c,0) as c, isnull(b.d,0) as d
from
a full join b
on
a.id=b.id
isnull(a.id,b.id) as id
isnull(a.a,0) as a, isnull(a.b,0) as b, isnull(a.c,0) as c, isnull(a.d,0) as d,
isnull(b.a,0) as a, isnull(b.b,0) as b, isnull(b.c,0) as c, isnull(b.d,0) as d
from a full join b on a.id=b.id