

CREATE VIEW dbo.EmployeeJobs_view
AS
SELECT     TOP 100 PERCENT dbo.jobs.job_desc, dbo.employee.fname, dbo.employee.lname
FROM         dbo.jobs INNER JOIN
                      dbo.employee ON dbo.jobs.job_id = dbo.employee.job_id
ORDER BY dbo.jobs.job_desc
