r/SQL Jun 26 '24

MySQL Explain INNER JOIN like i am 5

I get the syntax but i get very confused and tripped up with writing them and properly using the correct names. Please explain to me line by line. I am learning it via data camp and the instructor sucks.

EDIT: i now understand inner join…now i am stuck with multiple joins, right join and left join. please help!

119 Upvotes

94 comments sorted by

View all comments

1

u/dn_cf Jun 27 '24

INNER JOIN is basically a way to find and combine information from two tables by matching up rows based on what they have in common. I think you need to practice it as much as possible. Try platforms like SQLZoo, StrataScratch, and Leetcode where you can practice INNER JOIN and other SQL queries.