User`s guide

23.5.10.12 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 TableSalesRep TableManager TableManager Table
SalaryLast NameSalaryLast Name
$35,000.00Davolio$32,000.00Fuller
$48,300.00Dodsworth$32,000.00Fuller
$35,000.00Davolio$30,000.00Brid
$48,300.00Dodsworth$30,000.00Brid
$35,000.00Davolio$29,500.00Buchanan
$48,300.00Dodsworth$29,500.00Buchanan
$30,000.00Patterson$29,500.00Buchanan
$48,300.00Dodsworth$35,000.00Martin
$48,300.00Dodsworth$45,000.00Hellstern
2012-03-14541
Understanding Databases