Contents Index Rules describing the operation of key joins About common table expressions

ASA SQL User's Guide

Common Table Expressions


About this chapter 

The WITH prefix to the SELECT statements affords you the opportunity to define common table expressions. These can be used like temporary views within your query. This chapter describes how to use them.


About common table expressions
Typical applications of common table expressions
Recursive common table expressions
Parts explosion problems
Datatype declarations in recursive common table expressions
Least distance problem
Using multiple recursive common table expressions

Contents Index Rules describing the operation of key joins About common table expressions