Determining which table columns to join  How subqueries work


Chapter 5: Subqueries: Using Queries Within Other Queries

A subquery is a select statement that is nested inside another select, insert, update, or delete statement, inside a conditional statement, or inside another subquery.

You can also express subqueries as join operations. See Chapter 4, “Joins: Retrieving Data from Several Tables.”





Copyright © 2005. Sybase Inc. All rights reserved. How subqueries work

View this book as PDF