Where to find answers to frequently asked questions on SELECT Statements with JOIN and Subqueries in MySQL?

Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SELECT Statements with JOIN and Subqueries in MySQL. Clear answers are provided with tutorial exercises on joining multiple tables with inner and outer joins; using subqueries with IN, EXISTS, and FROM clauses; using UNION operations.

Types of Table Joins in MySQL

Query with an Inner Join in MySQL

Using Table Alias Names in MySQL

Query with a Left Outer Join in MySQL

Query with a Right Outer Join in MySQL

Query with a Full Outer Join in MySQL

Inner Join with the WHERE Clause in MySQL

Assign Names to Query Output Columns in MySQL

What Is a Subquery in MySQL

Using Subqueries with the IN Operator in MySQL

Using Subqueries with the EXISTS Operator in MySQL

Using Subqueries in the FROM Clause in MySQL

Counting Groups Returned from GROUP BY in MySQL

Returning Top 5 Rows in MySQL

Returning the Second 5 Rows in MySQL

Merge Outputs from Two Queries in MySQL

Please note that all answers and tutorials are based on MySQL 5.0. Tutorial exercises should be executed with "mysql" or other MySQL client programs. It is also assumed that you have a MySQL user account and a predefined database with enough privileges.

Some sample scripts requires database tables created by other samples in the beginning of the collection.

For questions on SELECT statement basics and GROUP BY, see the previous FAQ collection.

⇒ Types of Table Joins in MySQL

⇐ Using Group Functions in the ORDER BY Clause in MySQL

⇑⇑ MySQL Database Tutorials