NOT IN vs. NOT EXISTS when NULL values are involved
NOT IN does not behave as you would expect when NULL values are involved. Suppose you have the following tables: CDFIELD DSFIELD 1 ALPHA 2 BETA TABLEA CDFIELD DSFIELD 1 GAMMA NULL DELTA…
Read article