LISTING 3: The V_TimecardPlusEmp View

CREATE VIEW V_TimecardPlusEmp
(
TOrgCode,
TKOrgCode,
TWorkDate,
TWorkHours,
TEmpNo
)
AS
SELECT DISTINCT
Timecard.OrgCode,
Timekeep.OrgCode,
TWorkDate,
TWorkHours,
Timecard.TEmpNo

FROM timecard
INNER JOIN timekeep ON Timecard.TEmpNo = Timekeep.EmpNo
INNER JOIN V_SecAccess ON Timecard.OrgCode = V_SecAccess,OrgCode OR
Timekeep.OrgCode = V_SecAccess.OrgC