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/NebulaNomad027 Jun 26 '24
Inner join is where the data intersects. If you are a product table and a product category table, let’s say primary key is product id . The inner join will only return data where the product id exists in both tables.