SQL JOINs are used to combine rows from two or more tables based on a related column. They help retrieve meaningful data relationships.

What is the difference between INNER JOIN and LEFT JOIN?

INNER JOIN returns only matching records from both tables, while LEFT JOIN returns all records from the left table and matching records from the right table.

When should I use FULL OUTER JOIN?

FULL OUTER JOIN is useful when you want all records from both tables, with NULLs filled in for non-matching rows. It’s helpful for comprehensive comparisons.

What is a CROSS JOIN?

CROSS JOIN produces the Cartesian product of two tables, meaning every row from one table is combined with every row from the other.

SQL JOINs Interactive Demo

Master SQL JOINs with Fullstackgada’s fun approach! 📊

More Diagrams

Follow for More

Members Table

ID	Name	Role
1	Jethalal	Society Secretary
2	Bhide	Tuition Master
3	Popatlal	Post Office
4	Tapu	Student
5	Bapuji	Retired

GamesParticipated Table

PlayerID	Game Name	Score
1	Cricket	45
2	Carrom	12
3	Chess	8
4	Football	22
6	Volleyball	15

INNER JOIN Result

INNER JOIN

Shows only members who have played a game. Bapuji won’t appear because he hasn’t played any games. Guest (ID 6) also won’t appear because they’re not in the Members table.

Members

Games

ID	Name	Role	Game Name	Score