| [ < ] | [ > ] | [ << ] | [ Up ] | [ >> ] | [Top] | [Contents] | [Index] | [ ? ] |
MySQL Version 4.1 supports subqueries and derived tables.
A "subquery" is a SELECT statement nested within another statement.
A "derived table" (an unnamed view) is a subquery in the FROM clause
of another statement.
See section Subquery Syntax.
For MySQL versions older than 4.1, most subqueries can be rewritten using joins or other methods. See Rewriting Subqueries as Joins for Earlier MySQL Versions for examples that show how to do this.
This document was generated on July, 26 2004 using texi2html 1.70.
