Navigation:  Advantage Developer's Guide > Part I - Advantage and Advantage Data Architect > Chapter 6 - Views >


     Views That Use Views

Advantage Database Server v8.1: A Developer’s Guide

by Cary Jensen and Loy Anderson

  © 2007 Cary Jensen and Loy Anderson. All rights reserved.

Previous pageReturn to chapter overviewNext page

Earlier in this chapter, you learned how to execute a SQL SELECT statement against the Employee Tab view using the SQL Utility. Since a view itself is defined using a SQL statement, there is no reason why the SQL SELECT statement used in a view cannot query a view.

Views that use views can be employed in a number of interesting ways. Two of these techniques are covered in this section. In the first technique, you will learn how views can be used to modularize operations on your data. In the second, you will see how a view can be used as a temporary table.