SQL Joins (with diagrams)

Was looking for how to do  Left (inner join) excluding the intersection part, and i find that 'Coding Horror' Blog has the best explanation and Solution for me

Coding Horror: A Visual Explanation of SQL Joins