Databases Reference
In-Depth Information
Figure 5-18.
The Calendar page type
4.
In the next step, choose SQL calendar.
5.
Specify Employee Leave calendar as the name of your page.
6.
Click through the next step. You will now see an area where you can define the
SQL for the calendar; specify the SQL shown in Listing 5-6.
Listing 5-6.
Specifying the SQL for the Calendar
SELECT EmpName, Leavedate FROM Employees,EmpLeave WHERE Employees.EmpID=EmpLeave.EmpID
7.You should now see the screen shown in Figure 5-19.
