In this Step, we have been told the following -
Here, we get a null value even though the two tables are not identical. That’s because all of the values for
test_table_2are also in
test_table_1, even if
test_table_1has an extra value.
It says we get a null value from the above. Then we have -
Equates to False as both are not null
But that’s incorrect. The second part of the above image (after the
AND) is Null as per the previous image.
In the end, that
AND still results in a False. But the explanation seems wrong.
Am I overlooking something here?