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

Manager Table Manager Table SalesRep Table SalesRep Table
Salary Last Name Salary Last Name
$32,000.00 Fuller $48,300.00 Dodsworth
$30,000.00 Brid $48,300.00 Dodsworth
$29,500.00 Buchanan $48,300.00 Dodsworth
$35,000.00 Martin $48,300.00 Dodsworth
$29,500.00 Buchanan $30,000.00 Patterson
In this table, there is no relationship established between sales
representatives and sales managers. Since all managers have seniority over
all sales representatives, a company might find it necessary to check if any
representatives make more money than any managers, evidence of a salary
problem that needs to be remedied.
Greater Than Or Equal [>=] link
The result set from a Greater Than Or Equal link includes all records in which
the linked field value in the primary table is greater than or equal to the linked
field value in the lookup table. The example here is identical to the example
for the Greater Than join, except that it uses the Greater Than Or Equal link:
SELECT SalesRep.'Last Name',
SalesRep.'Salary',
Manager.'Last Name',
Manager.'Salary'
FROM 'SalesRep' SalesRep,
'Manager' Manager
Crystal Reports 2008 SP3 User's Guide 689
25 Understanding Databases
Linking tables