NULLs in INNER and LEFT JOINs

Concepts: sqlNullInJoins

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