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

Less Than [<] link
The result set from a Less Than link includes all records in which the linked
field value in the primary table is less than the linked field value in the lookup
table. Using the Less Than link, you can compare sales representative and
manager salaries in a different direction. Once again, the Salary field in each
table is used as the link field. This time, though, you link from the Manager
table to the SalesRep table using a Less Than link on the linked Salary fields:
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 a slightly different table than that produced
by the Greater Than link:
SalesRep Table SalesRep Table Manager Table Manager Table
Salary Last Name Salary Last Name
$35,000.00 Davolio $32,000.00 Fuller
$48,300.00 Dodsworth $32,000.00 Fuller
$35,000.00 Davolio $30,000.00 Brid
$48,300.00 Dodsworth $30,000.00 Brid
$35,000.00 Davolio $29,500.00 Buchanan
Crystal Reports 2008 SP3 User's Guide 691
25 Understanding Databases
Linking tables