User`s guide

23.5.10.13 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:
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
$30,000.00Patterson$30,000.00Brid
$35,000.00Davolio$29,500.00Buchanan
$48,300.00Dodsworth$29,500.00Buchanan
$30,000.00Patterson$29,500.00Buchanan
$35,000.00Davolio$35,000.00Martin
$48,300.00Dodsworth$35,000.00Martin
2012-03-14542
Understanding Databases