Home | Previous Page | Next Page

Composing Advanced SELECT Statements

In This Chapter

Using the GROUP BY and HAVING Clauses

Using the GROUP BY Clause

Using the HAVING Clause

Creating Advanced Joins

Informix Extension to Outer Join Syntax

ANSI Join Syntax

Left Outer Join

Right Outer Join (IDS)

Simple Outer Join on Two Tables

Outer Join for a Simple Join to a Third Table

Outer Join of Two Tables to a Third Table

Joins That Combine Outer Joins

Subqueries in SELECT Statements

Correlated Subqueries

Subqueries in SELECT Statements

Subqueries in a Projection Clause

Subqueries in WHERE Clauses

Single-Valued Subqueries

Correlated Subqueries

Handling Collections in SELECT Statements (IDS)

Collection Subqueries

Omitting the Item Keyword in a Collection Subquery

Specifying the ITEM Keyword in a Collection Subquery

Collection-Derived Tables

Using ORDER BY with UNION

Using UNION ALL

Using Different Column Names

Using UNION with Multiple Tables

Using a Literal in the Projection Clause

Using a FIRST Clause

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]