select * from tbl1 minus select * from tbl2 is null
112397Jun 2 2009 — edited Jun 2 2009hi all,
I have 2 tables with the same 8 columns, one column is null from top to bottom.
tbl1 has 60,000 rows, tbl2 has 70,000 rows.
I need to see the 10, 000 rows in tbl2 that are different from the rows from tbl1.
If I execute select * from tbl1 intersect select * from tbl2 I get all 60,000 rows from tbl1.
However, if I execute select * from tbl2 minus select * from tbl1 I get no rows ?
I can't figure out why, can anyone help, please.
Thanks,
kowalsky