SQL SELECT Statements with JOIN and Subqueries MySQL / General Guides
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.
Mysql Sub Queries, introduction MySQL / General Guides
Mysql icon Mysql now offers sub queries/sub selects. They can help you write faster and shorter code. You don't need to do that much programming in PHP, just let mysql do the work :-)