User`s guide

Orders TableCustomer TableCustomer Table
Order AmountCustomer NameCustomer ID
19164.30BG Mountain Inc.53
1683.60BG Mountain Inc.53
15716.40Hansen MTB Inc.57
1956.20La Bomba de Bicicleta58
24580.50Mountain Toad60
7911.80SFB Inc.62
19766.20Sierra Bicycle Group63
12763.95Sierra Bicycle Group63
8233.50Sierra Mountain64
23.5.10.10 Greater Than [>] link
The result set from a Greater Than link includes all records in which the linked field value from the
primary table is greater than the linked field value in the lookup table. As an example, a company may
want to compare the salaries made by all their sales representatives to the salaries made by all their
sales managers. The company executives want to make sure no sales representative is making more
money than any manager.
With this in mind, you can link the SalesRep table to the Manager table by the Salary field in each table
using a Greater Than link:
SELECT SalesRep.'Last Name',
SalesRep.'Salary',
Manager.'Last Name',
Manager.'Salary'
FROM 'SalesRep' SalesRep,
2012-03-14538
Understanding Databases