LISTING 2: The V_Timecard View

CREATE VIEW V_Timecard
(
OrgCode,
TWorkDate,
TWorkHours,
TEmpNo
)
AS
SELECT
Timecard.OrgCode,
TWorkDate,
TWorkHours,
TEmpNo

FROM timecard INNER JOIN V_SecAccess ON Timecard.OrgCode=
V_SecAccess.OrgCode