Joins with SQL derived tables  Using views with SQL derived tables

Chapter 9: SQL Derived Tables

Creating a table from a SQL derived table

Data obtained from a SQL derived table can then be inserted into a new table, as in the following example.

select pubdate into pub_dates
   from (select pubdate from titles) dt_e
            where pubdate = "450128 12:30:1PM"

Here, data from the SQL derived table dt_e is inserted into the new table pub_dates.





Copyright © 2005. Sybase Inc. All rights reserved. Using views with SQL derived tables

View this book as PDF