SELECT NVL(TABLE_A.PK, TABLE_B.PK) PK, NVL(TABLE_A.VAL, TABLE_B.VAL) VAL
FROM TABLE_A FULL OUTER JOIN TABLE_B ON TABLE_A.PK = TABLE_B.PK
SELECT NVL(TABLE_A.PK, TABLE_B.PK) PK, NVL(TABLE_A.VAL, TABLE_B.VAL) VAL
FROM TABLE_A FULL OUTER JOIN TABLE_B ON TABLE_A.PK = TABLE_B.PK
•
NVL for Oracle, IFNULL for MySQL, ISNULL for SqlServer
-slow_quick-
♂
(0 bytes)
()
03/06/2013 postreply
08:47:09