Views Derived From Other Views

You can define a view in terms of another view.

For example:
create view hiprice_computer 
as select title, price 
from hiprice 
where type = "popular_comp"
Parent topic: select Statement Usage with create view