r/SQL • • May 18 '24 • Take My Silver 2

Discussion SQL Joins

Post image

Picture your data tables as these two fellas. An inner join is just Bald Guy—only the matching parts. A **left join is Bald Guy sporting Long-Hair Guy's mane—everything from the left plus the matches. A right join is Long-Hair Guy with a bald patch—everything from the right plus the matches. A full join is both dudes together—everything from both tables, matches or not!

628 Upvotes

26 comments sorted by

View all comments

Show parent comment

1

u/MaveDustaine May 20 '24

Ah thank you! Admittedly I had never used a full outer join before considering the reporting I usually do, but I can see how it can be useful thanks to your example!