SQL SERVER – Better Performance – LEFT JOIN or NOT IN? | Journey to SQL Authority with Pinal Dave

It looks like LEFT JOIN gives more accurate results than NOT IN function. This query returned 0 records. SELECT DISTINCT(A.CSN_ID) FROM TRG_LINKED_ENCS A WHERE A.CSN_ID not in (SELECT DISTINCT(CSN_ID) FROM TPL_TXDAYS ) This query ...

blog.sqlauthority.com