Databases Reference
In-Depth Information
Figure 5-1.
The Classic Report
4.
Next, specify a name for your report. After you've done that, skip past the next
step. You will now be allowed to enter the SQL statement for the report.
Specify the SQL statement shown in Listing 5-2.
Listing 5-2.
Specifying the SQL for the Classic Report
SELECT * FROM EMPLOYEES LEFT JOIN EMPLEAVE ON EMPLOYEES.EMPID=EMPLEAVE.EMPID
You should now see the screenshot shown in Figure 5-2.
