view example

Add a comment

CREATE VIEW [dbo].[employeeView]

       AS SELECT employeeTBL.fullName fullName,

                 roleTBL.name roleName,

                 employeeTBL.phone phone,

                 employeeTBL.isActive isActive,

                employeeTBL.address addess

       FROM employeeTBL INNER JOIN roleTBL ON employeeTBL.roleID = roleTBL.I