SQL Join

Joins #

Every join is CROSS join with some twist.

Inner Join (or Join) #

• Inner join is CROSS join with filter

Where is Left where is Right? #

• Left most table is the one you are LEFT JOIN <THIS ONE HERE is LEFT>
• Right most table is RIGHT JOIN <here is right>

Resources #

• Visually Explaining Joins
• Visualize Joins

---

• Next: SQL Count
• Previous: How JS is loaded in browser env