Joining Data in SQL

Introduction to Joins

1. Inner Join
2. Inner Join via Using
3. Self Join
4. Case When and Then
5. Into Command

Outer joins and cross joins

1. Left Join
2. Right Join
3. Full Join
4. Cross Join