Database · Medium · ProEXISTS vs IN vs JOIN — which should you use and why does NOT IN break with NULLs?DatabaseSQLFresherPerformance