A Deeper Look at Advanced Select Queries: New Premium Tutorial

John Cox on Jul 22nd 2010 with 7 comments

Tutorial Details

Program: MySQL
Difficulty: Moderate
Estimated Completion Time: 20 Minutes

Download Source Files

Thanks for supporting the site, feel free to download the ZIP file for this tutorial.
Source files for this tutorial are available to Premium members.
Get a Premium Membership

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 $19 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.

Enjoyed this Post?

Subscribe to our RSS Feed, Follow us on Twitter or simply recommend us to friends and colleagues!

By John Cox

Rollover to read this author's bio or click through to see a full list of posts by this author.

John is fascinated with innovation of all types. He works by day as a technical business consultant identifying and solving challenging business problems with technology, and by night as a husband and father of two. He has been on the frontier of web development for the past fifteen years, but still learns something new everyday. You can catch up with him through Wyome.com.

Plus Premium

Note: Want to add some source code? Type <pre><code> before it and </code></pre> after it. Find out more

Paul du Long
Finally :D

http://wyome.com John Cox
I hope it was helpful:)
http://www.frutesca.com mhankins
I agree, finally.

http://www.thedevelopertuts.com Bratu Sebastian
Ooh, nice! As long as mysql won’t mind … :)
Anouck
In only 20 minutes you explain all the difficulties of joins, selects and plenty more??? Is it really advanced??

Patrick
Joins are really easy to use – you only have to understand how they’re working. Yes, you CAN learn it in 20 Minutes. For me it takes only 10 minutes.