To a SQL novice, JOINs can be intimidating and somewhat frustrating. Even when you think you have the query nailed, along comes an unexpected result which make you throw up your arms in surrender to the SQL gods. In this tutorial, we are going to build upon the excellent quick tip of working with MySQL and INNER JOIN recently posted and crack open the real power of a SELECT statement. Become a Premium member to access this tutorial, and all of the other fantastic articles and screencasts across all of the Tuts sites.
What you’ll Learn About:
- Why being specific with your queries is so important
- INNER JOINs
- OUTER JOINs
- Sub-Selects
- UNIONs
- …and plenty more
Join Net Premium
For those unfamiliar, the family of Tuts+ sites runs a premium membership service. For $9 per month, you gain access to exclusive premium tutorials, screencasts, and freebies from Nettuts+, Psdtuts+, Aetuts+, Audiotuts+, and Vectortuts+! For the price of a pizza, you’ll learn from some of the best minds in the business. Become a Premium member.