A view is a virtual table.it is formed by combining one or more real tables.
EXAMPLE:
create view vw_demo
as
select p.firstname,p.paddress,d.coursename
from students p inner join course d
on p.studentid=d.studentid
How to execute a view?
Select * from vw_demo