HP Intelligent Management Center Standard Software Platform - Manual (Page 692)

SalesRep Table SalesRep Table Manager Table Manager Table
Salary Last Name Salary Last Name
$48,300.00 Dodsworth $29,500.00 Buchanan
$30,000.00 Patterson $29,500.00 Buchanan
$48,300.00 Dodsworth $35,000.00 Martin
$48,300.00 Dodsworth $45,000.00 Hellstern
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:
692 Crystal Reports 2008 SP3 User's Guide
Understanding Databases 25
Linking tables