View in sql server

create view flightinfo
as
select fname,finformation from flights
go

select * from flightinfo
--
create view employee
as
select emp.ename,emp.esalary,dept.dname from emp join dept on emp.deptno=dept.deptno
go