Writing SELECT queries for SQL databases
When you want to get results from a database you issue a select query. With this query you can limit the results based on certain criteria, sort it, and subsort it. You can do a lot with this including selecting data from multiple tables.

Using SELECT to retrieve data
This tutorial deeply covers the SELECT statement of the T-SQL/SQL language. Starts from the basics - how to retrieve the values inside a column to ordering data, selecting multiple columns and then tables, joining them...

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.

Retrieving Information from a Table
The SELECT statement is a MUST if you plan on using databases.

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

Filtering Data
In this tutorial, you will learn how to use the SELECT statement's WHERE clause to specify search conditions.

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

Retrieving Data
In this tutorial, you'll learn how to use the SELECT statement to retrieve one or more columns of data from a table.

Sorting Retrieved Data
In this tutorial, you will learn how to use the SELECT statement's ORDER BY clause to sort retrieved data as needed.

MySQL SELECT query from PHP script help, examples, homework, photoshop tutorials, free tutorials, tu
This tutorial will show you how to use MySQL querys to database in your PHP scripts.

Grouping Data
In this tutorial, you'll learn how to group data so you can summarize subsets of table contents. This involves two new SELECT statement clauses: the GROUP BY clause and the HAVING clause.

MySQL and SQL
This tutorial covers the following:
Introduction to relational databases and relational modeling; The MySQL command interpreter and the basic features of MySQL; Using SQL to create and modify databases, tables, and indexes. Using SQL to insert, delete, and update data; The SQL SELECT statement for querying, with examples of simple and advanced queries; Functions and operators in SQL and MySQL; Advanced features, including managing indexes and keys, tuning the MySQL DBMS, security, and the limitations of MySQL