Oracle Minus query. How can I get a result with NULLS if the top SQL and the bottom SQL don't contai
- by George
CREATE TABLE NewTable AS
SELECT A,B,C FROM Table1
minus
SELECT A, B, C From Table2
Create a new table with NULL values for column A
when neither Table1 or Table2 had NULL values for this column.
Yet,
SELECT * FROM
(
SELECT A,B,C FROM Table1
minus
SELECT A, B, C From Table2
)
WHERE A IS NULL
return 0 rows?
