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

WHERE SalesRep.'Salary' >=
Manager.'Salary'
This statement might produce data such as this:
Manager Table Manager Table SalesRep Table SalesRep Table
Salary Last Name Salary Last Name
$32,000.00 Fuller $35,000.00 Davolio
$30,000.00 Brid $35,000.00 Davolio
$29,500.00 Buchanan $35,000.00 Davolio
$35,000.00 Martin $35,000.00 Davolio
$45,000.00 Hellstern $48,300.00 Dodsworth
$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
$30,000.00 Brid $30,000.00 Patterson
$29,500.00 Buchanan $30,000.00 Patterson
690 Crystal Reports 2008 SP3 User's Guide
Understanding Databases 25
Linking tables