SQL Select Statement - SubSelect
To extract more complex relationships from tables, you often need subselects (or "subqueries"). In this video, we'll cover the most important details for using such subselects. We'll also briefly discuss updating from a SELECT statement, as this is a similar concept to subqueries.
You can find an overview of further information at http://www.codeconcert.de