Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools

Posted by Ben Bastow
Ben Bastow
24,657 Points

Still Dont Understand JOIN in MYSQL

Hey!

I dont understand the JOIN function and im finding it really confusing to understand (is it just me?). Could someone please explain how you use the JOIN function in mysql??

Thanks in Advance

1 Answer

Saskia Lund
Saskia Lund
5,673 Points

Hi Ben!

I just hope I am getting your question right. JOIN let's you basically compare and see the possible intersections of two or more separate tables.

There is an article here http://www.sitepoint.com/understanding-sql-joins-mysql-database/ that explains JOIN and how it actually works in a very comprehensive way.

Hugs Sas

Ben Bastow
Ben Bastow
24,657 Points

Thank you!!

Ben Bastow
Ben Bastow
24,657 Points

Does a JOIN change the table in the database or does it just show you the data joined?