SQL JOINs Explained Like You're Five (Using Shah Rukh Khan Movies)

If SQL JOINs confuse you, don't worry.

Most tutorials explain JOINs using boring examples like Customers and Orders.

Let's use something more fun.

Let's use Shah Rukh Khan movies.

The Setup

Imagine you're creating a Bollywood database.

Movies:

• 1 → DDLJ
• 2 → Pathaan
• 3 → Jawan
• 4 → Don

Directors:

• 1 → Aditya Chopra
• 2 → Siddharth Anand
• 3 → Atlee
• 5 → Farah Khan

Notice something?

• Don exists without a matching director.
• Farah Khan exists without a matching movie.

This is exactly why SQL JOINs exist.

Think of a JOIN as a matchmaker.

Its job is simple:

Find records from two tables that belong together.

INNER JOIN

INNER JOIN only keeps records that match in both tables.

Think of It Like a Movie Award Function

Only people who have both:

• A nomination
• An invitation

can enter.

Result

• DDLJ → Aditya Chopra
• Pathaan → Siddharth Anand
• Jawan → Atlee

Don is removed.

Farah Khan is removed.

Easy Memory Trick

INNER JOIN = Only Matches

LEFT JOIN

LEFT JOIN keeps everything from the left table.

Think of It Like SRK Hosting a Party

SRK says:

"Every movie from my list gets invited."

Even if a director is missing.

Result

• DDLJ → Aditya Chopra
• Pathaan → Siddharth Anand
• Jawan → Atlee
• Don → NULL

Don stays because it belongs to the Movies table.

Easy Memory Trick

LEFT JOIN = Keep My Gang

RIGHT JOIN

RIGHT JOIN keeps everything from the right table.

Result

• DDLJ → Aditya Chopra
• Pathaan → Siddharth Anand
• Jawan → Atlee
• NULL → Farah Khan

Farah Khan stays because she belongs to the Directors table.

Easy Memory Trick

RIGHT JOIN = Keep Their Gang

FULL OUTER JOIN

Nobody gets removed.

Everybody gets invited.

Result

• DDLJ → Aditya Chopra
• Pathaan → Siddharth Anand
• Jawan → Atlee
• Don → NULL
• NULL → Farah Khan

Easy Memory Trick

FULL JOIN = Everyone Stays

The 30-Second Cheat Sheet

• INNER JOIN → Only matching records

• LEFT JOIN → Keep everything from the left table

• RIGHT JOIN → Keep everything from the right table

• FULL JOIN → Keep everything from both tables

Final Takeaway

Don't memorize definitions.

Remember the party.

• INNER JOIN → Only couples enter.
• LEFT JOIN → My gang stays.
• RIGHT JOIN → Their gang stays.
• FULL JOIN → Everyone stays.

Once this clicks, SQL JOINs become common sense.