MySQL FAQs - SQL SELECT Statements with JOIN and Subqueries
A collection of 16 FAQs on MySQL SELECT statements with JOIN and subqueries. 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.

Joining Tables
In this tutorial, you'll learn what joins are, why they are used, and how to create SELECT statements using them.

Combining Queries
In this tutorial you'll learn how to use the UNION operator to combine multiple SELECT statements into one result set.

5 Useful MySQL Functions And Control Flows
If statements have been a life saver on many occasions. They are invaluable for checking a value then returning another value different from the one stored in the table...

Updating & Deleting Data
In this tutorial, you will learn how to use the UPDATE and DELETE statements to enable you to further manipulate your table data.

Working with MySQL
In this tutorial, you'll learn how to connect and login to MySQL, how to issue MySQL statements, and how to obtain information about databases and table.

Managing Transaction Processing
In this tutorial you'll learn what transactions are and how to use COMMIT and ROLLBACK statements to manage transaction processing.

Getting Information About Databases and Tables
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and tables it supports.