回複：問個SQL的問題

來源: 於 2013-03-06 08:35:23 [博客] [舊帖] [給我悄悄話] 本文已被閱讀：次

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