Understand Query
| Hello |
I need to understand why those queries doesn't send the same result :
-- TAB2 contains rows with ref_id_tab1 null
select count(*)
FROM TAB1
where id not in ( select ref_id_tab1
| FROM TAB2 | |
| where ref_id_tab1 is not null); |
COUNT(*)
----------
| 5 |
select count(*)
FROM TAB1
where id not in ( select ref_id_tab1
| FROM TAB2 | |
| where ref_id_tab1); |
COUNT(*)
----------
0 Regards Djm |