Operation Manual

Understanding Databases
Linking tables
25
508 Crystal Reports User’s Guide
Less Than Or Equal [<=] link
The result set from a Less Than Or Equal link includes all records in which the
linked field value in the primary table is less than or equal to the linked field
value in the lookup table. The example here is identical to the example for the
Less Than link, except that it uses the Less Than Or Equal link:
SELECT Manager.‘Last Name‘,
Manager.‘Salary‘,
SalesRep.‘Last Name‘,
SalesRep.‘Salary‘
FROM ‘Manager‘ Manager,
‘SalesRep‘ SalesRep
WHERE Manager.‘Salary‘ <=
SalesRep.‘Salary‘
This SQL statement produces data similar to the following:
Brid $30,000.00 Dodsworth $48,300.00
Buchanan $29,500.00 Davolio $35,000.00
Buchanan $29,500.00 Dodsworth $48,300.00
Buchanan $29,500.00 Patterson $30,000.00
Martin $35,000.00 Dodsworth $48,300.00
Hellstern $45,000.00 Dodsworth $48,300.00
Manager Table Manager Table SalesRep Table SalesRep Table
Last Name Salary Last Name Salary
Manager Table Manager Table SalesRep Table SalesRep Table
Last Name Salary Last Name Salary
Fuller $32,000.00 Davolio $35,000.00
Fuller $32,000.00 Dodsworth $48,300.00
Brid $30,000.00 Davolio $35,000.00
Brid $30,000.00 Dodsworth $48,300.00
Brid $30,000.00 Patterson $30,000.00
Buchanan $29,500.00 Davolio $35,000.00
Buchanan $29,500.00 Dodsworth $48,300.00
Buchanan $29,500.00 Patterson $30,000.00
Martin $35,000.00 Davolio $35,000.00
Martin $35,000.00 Dodsworth $48,300.00
Hellstern $45,000.00 Dodsworth $48,300.00