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"
View this book as PDF