如何合并
下表是我把两个表full join出来的结果,怎么让它变成表2中的结果?
表1:
A B C D
000145000137
0026490026326
003112NULLNULL
003257003263
00371200373
NULLNULL004235
NULLNULL004311
表2:
00014537
002649326
003112NULL
00325763
0037123
0042NULL35
0043NULL11
[解决办法]
select coalesce(a,c) A,
B,
D
from [表1] a full join [表2] b
on a.id=b.id
[解决办法]
select (case when A is null then C else A end),B,D from Ta
[解决办法]
create table gjlsss
(
A varchar(10),
B varchar(10),
C varchar(10),
D varchar(10)
)
insert into gjlsss
select '0001 ', '45 ', '0001 ', '37 ' union all select
'0026 ', '49 ', '0026 ', '326 ' union all select
'0031 ', '12 ', 'NULL ', 'NULL ' union all select
'0032 ', '57 ', '0032 ', '63 ' union all select
'0037 ', '12 ', '0037 ', '3 ' union all select
'NULL ', 'NULL ', '0042 ', '35 ' union all select
'NULL ', 'NULL ', '0043 ', '11 '
select (case A when 'null ' then C else A end)as AC ,B,D from gjlsss
===============================
00014537
002649326
003112NULL
00325763
0037123
0042NULL35
0043NULL11
[解决办法]
--假設列名都為ID, Value
Select
IsNull(A.ID, B.ID) As ID,
A.Value,
B.Value
From
表1 A
Full Join
表2 B
On A.ID = B.ID
