Views used with outer joins  distinct views

Chapter 11: Views: Limiting Access to Data

Views derived from other views

You can define a view in terms of another view, as in this example:

create view hiprice_computer 
as select title, price 
from hiprice 
where type = "popular_comp" 




Copyright © 2005. Sybase Inc. All rights reserved. distinct views

View this book as PDF