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: 137
Filed under:
plsql
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?
© Stack Overflow or respective owner
