NULLs in INNER and LEFT JOINs

Understanding NULL in JOINs JOIN Type Behaviors LEFT JOIN and NULL Advanced JOIN Patterns