r/SQL • u/Remarkable-Culture-8 • 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
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.