Example:
  Objective: In this example, we will use SQL joins to create views.Â
           CREATE VIEW VW_ProjectDetail AS                                                                                SELECT e.FirstName, e.LastName , e.Emailaddress, P.Project                                                             FROM Tbl_Emp as e INNER JOIN Tbl_Project as p                                                                     on e.Ecode = p.Ecode;
  View Query:
           SELECT * FROM VW_ProjectDetail;
  Output: