Since NULL represents an unknown value, looking for values in the outer table that are not unknown (i.e. employees’ ids that are not in a list that contains NULL values) would return 0 rows.
11 August 2019
NOT IN and NULL ( a dangerous combination)
Since NULL represents an unknown value, looking for values in the outer table that are not unknown (i.e. employees’ ids that are not in a list that contains NULL values) would return 0 rows.
07 August 2019
Subscribe to:
Posts (Atom)