FULL OUTER JOIN 用例一则--合并表

例：

表一  A       10        表二   C     40                               合并表    A        10      NULL
          B       20                   D     50          ---------&gt>                    B        20      NULL
          C       30                   E     60                                               C        30       40
                                                                                                       D      NULL   50
                                                                                                       E   NULL     60

CREATE TABLE #T
(
 Col1   NCHAR(1),
 Col2 INT
)

INSERT INTO #T VALUES('A',10);
INSERT INTO #T VALUES('B',20);
INSERT INTO #T VALUES('C',30);

CREATE TABLE #S
(
 Col1 NCHAR(1),
 COL2 INT
)

INSERT INTO #S VALUES('C',40);
INSERT INTO #S VALUES('D',50);
INSERT INTO #S VALUES('E',60);

SELECT ISNULL(K.Col1,F.Col1) AS Col,K.Col2 AS TCol,F.Col2 AS SCol
FROM #T K FULL OUTER JOIN #S F ON K.Col1=F.Col1

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15042150/viewspace-557551/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15042150/viewspace-557551/