SQL 3 table Join's With View's

create database BBB

use BBB

create table Location(id int primary key,name varchar(255))

create table Department(id int primary key,name varchar(255),loc int foreign key references location(id))

create table Employe(id int primary key,name varchar(255),Department int foreign key references Department(id))

insert into Location values(1,'Karachi'),(2,'Lahore'),(3,'Islamabd')

insert into Department values(1,'Marketing',1),(2,'SRO',2),(3,'Placement',3)

insert into Employe values(1,'Akhlas',1),(2,'Hamza',2),(3,'Nabeel',3)

select * from Location

select * from Department

select * from Employe

create view BBBview
AS
select E.name As ENAME , D.name As DNAME ,L.name AS Location from Employe E join
Department D on E.id=D.id join Location L on D.loc=L.id

create view Managerview
AS
select name from Employe
select name from Location
select name from Department

select * from BBBview
select * from Managerview