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 Database Foundations Joining Relational Data Between Tables in SQL Joining Tables and Aliasing

Diego Salazar
Diego Salazar
2,206 Points
Posted by Diego Salazar
Diego Salazar
2,206 Points

What's the difference between using WHERE and ON in a Select?

I don't get at all how when should I use WHERE or ON in my queries.

2 Answers

Jose Soto
Jose Soto
23,407 Points
Jose Soto
Jose Soto
23,407 Points

When you JOIN two tables, you need specify which field you will be joining ON. Once the join is complete, you can use a WHERE clause to limit the results.

Diego Salazar
Diego Salazar
2,206 Points
Diego Salazar
Diego Salazar
2,206 Points

Thanks a lot! That sound great.