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
Data type declarations in recursive common table expressions
Least distance problem
Using multiple recursive common table expressions
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.