SQL joins explained using Hinge

[u/qazplm903]

I know when people are starting out, SQL joins can be a bit confusing so I broke it down in a small vid using Hinge as an example

https://www.instagram.com/reel/Degl_hnoRsz/?mdxt=MTk5dXE2NHZreTR4aw==

Summary of the breakdown is -

• Table A: people you've liked
• Table B: people who've liked you
• Both share one key: person_id

The 4 joins:

• INNER JOIN: only the mutual likes. Someone has to be in both tables to show up.
• LEFT JOIN: everyone you liked. If they didn't like you back, their side comes back as NULL.
• RIGHT JOIN: the mirror image, everyone who liked you, with NULL where you didn't like them. In practice most people just swap the tables and use a LEFT JOIN.
• FULL OUTER JOIN: everyone from both tables, with NULLs on whichever side is missing.

Hope this helps!

[u/Ordinary_Beyond3737]

Thanks for this I'm unfortunately well versed with hinge but still learning SQL

[u/qazplm903 → u/Ordinary_Beyond3737]

Doing well on Hinge is probably harder than doing well with SQL these days 😂

[u/MarsupialLeast145]

Solid explanation! :ok

[u/qazplm903 → u/MarsupialLeast145]

Thanks! Hope it’s helpful 😁

[u/Thrilltwo]

Instructions unclear, I used left join but all of the other side just shows NULL?

[u/qazplm903 → u/Thrilltwo]

That means there’s no matches on the right, there’s an issue with your ON conditions. Check the columns you are joining on and make sure the data types match as well

[u/homequrl → u/qazplm903]

And if you’re my company, try to throw an upper or lower on both fields bcus they do not make any of their data sets case sensitive consistent between table!!!!

[u/qazplm903 → u/homequrl]

Facts! Had to deal with that so many times 😭

[u/TheGenericUser0815]

Haha, very good.

[u/qazplm903 → u/TheGenericUser0815]

Thanks!

[u/Difficult_Paint3162]

Feel free to visit my website: Learning SQL | Real People. Real Problems. Practical SQL. No cost or sign-up required, but focuses on understanding business questions and using SQL to get the answers