ALLBASE/SQL Reference Manual > Chapter 3 SQL Queries

Chapter 3 SQL Queries

	MPE documents
	Complete PDF
	Table of Contents
	Index

	E0300 Edition 9 ♥
	E0399 Edition 8
	E0897 Edition 7

Table of Contents

Using the SELECT Statement

Simple Queries

Complex Queries

UNION Queries
Using Character Constants with UNION
Subqueries
Special Predicates
Quantified Predicate
IN Predicate
EXISTS Predicate
Correlated Versus Noncorrelated Subqueries
Outer Joins

Using GENPLAN to Display the Access Plan

Generating a Plan
Displaying a Query Access Plan
Interpreting a Display

Updatability of Queries

This chapter describes SQL queries, through which you access the data in database tables. The following sections are presented:

Using the SELECT Statement
Simple Queries
Complex Queries
Using GENPLAN to Display the Access Plan
Updatability of Queries

The other kinds of data manipulation, using the INSERT, UPDATE, and DELETE statements, were presented in the chapter "Using ALLBASE/SQL."

Understanding the System Catalog

Using the SELECT Statement