Oracle Minus query. How can I get a result with NULLS if the top SQL and the bottom SQL don't contai

Posted by George on Stack Overflow See other posts from Stack Overflow or by George
Published on 2010-06-02T15:26:58Z Indexed on 2010/06/02 15:54 UTC
Read the original article Hit count: 143

CREATE TABLE NewTable AS
    SELECT A,B,C FROM Table1
    minus
    SELECT A, B, C From Table2

SELECT * FROM
(
   SELECT A,B,C FROM Table1
    minus
    SELECT A, B, C From Table2
) 
WHERE A IS NULL 

© Stack Overflow or respective owner